Home |
  Search |Quick FAQs Only


KNOWLEDGEBASE > ISSUE OVERVIEW


Previous
Add to Bookmarks
Print Issue Print Issue
Email Issue

Manually Importing PayPal transactions
ID: 5713 Category: Reckon One Status: Resolved Views: 90


Question:

How can I manually import my PayPal statement into the bank ledger account in Reckon One?


Applies to:

Reckon One user, who is not using our integrated PayPal payment service.



Solution:

You can manually download the transactions from PayPal in CSV file format and import it into your bank ledger accounts. You will have to map the data to the correct fields when importing.

Disclaimer: The contents of this article are for general guidance only and you should seek professional advice relating to your own specific circumstances before acting.

1) Import the Gross Amount.

2) Import the fee Separately.

When you download the PayPal transactions as CSV file format, it comes with a lot of information in the headers and columns, and not all of that information is required in Reckon One.

You will need to map the import to the appropriate columns within Reckon One. Care should be taken in the mapping, so you match the correct columns. We recommend importing one (1) transaction to begin with to ensure you have mapped the PayPal data correctly.

Most common field imported are Date; Description; Amount; and Reference

All transactions with positive amounts are treated as a ‘Money in’ within Reckon One.

All transactions with negative amounts are treated as ‘Money out’ within Reckon One.

If you have PayPal fee, you will have to import it separately. Please see this article for it.

Some manual edits are required in the file before you can import them.


Detailed steps.


Importing the Gross Amount.

Step 1: Mapping the import

As you can see from the above screenshots, when the PayPal transactions are imported there are lots of unnecessary columns.

1) Go to Import from row field and change the row number to 2. Since the first row in import is the column headers (as shown in step 1, above screenshot).

2) Go to the Date column (on imported data header) and select Date from the available Reckon One column header (as shown in step 2, above screenshot).

3) Go to the Name column (on imported data header) and select Description from the available Reckon One column header (as shown in step 3, above screenshot).

4) Go to the Gross column (on imported data header) and select Amount from the available Reckon One column header. (as shown in step 4).

5) Go to the Transaction ID column (on imported data header) and select Reference from the available Reckon One column header. (as shown in step 5, above screenshot)

6) Once done select Import the file.


Step 2: Recording the transactions

Once the transaction is imported it will be available under Transactions from bank area. You can import them individually into your bank ledger.

When Importing, you can either enter them as new transactions or allocate a payment to an existing invoice.

Step 2.1: Allocate a new payment

Step 2.2: Allocate a payment to existing customer invoice.


Step 2.1: Allocate a new payment

1) Go to transactions from bank

2) Select Allocate Receipt /Payment (step 2, above screenshot).

3) Select the appropriate contact (step 3).

4) Select Appropriate Account (step 4).

5) Select Accept to record the transaction.

6) Repeat the process for all remaining transactions.

Tip: You can also select ‘X’ to delete the transactions.

Step 2.2: Allocate a payment to existing customer invoice.

If the payment you received is for your existing invoice, you can also allocate the payment to the invoice, so it can be paid off.

1) Select Allocate receipt and Allocate detailed receipt.

2) Select the contact who this payment is from.

3) Enter any other relevant fields.

4) Scroll to the relevant invoice. Enter the amount under ‘How much to allocate field’.

5) Select save, once satisfied.

6) Repeat the process for any other payment.

This will now allocate the payment against the existing invoice and mark it off as paid.


Importing the PayPal Fee.

If you do have PayPal fees present on those transactions, you will need to import it separately.

You will re-import the same file, however, this time mapping the ‘Fee’ columns as the amount.

Please refer to this KB for more instruction on this.



Related Issues:
No related issue is available.

Submitted: 4/09/2018 Modified: 4/09/2018


Did this solution answer your question ? Please leave a comment, click here.

Rate how well this question was answered.
100% 75% 50% 25% 0%