has anyone done a manual upload from paypal

  • 2
  • Question
  • Updated 3 years ago
  • Answered
I am trying to manually upload transactions from paypal has anyone succeeded with this
Photo of Jennifer Enright

Jennifer Enright

  • 200 Points 100 badge 2x thumb

Posted 3 years ago

  • 2
Photo of Qwerty

Qwerty

  • 7,906 Points 5k badge 2x thumb
Hi Jennifer,

Here is how I did mine.

Step 1
When dowloading transactions from PayPal, use the 'comma delimited' format. This will give you a CSV file.

Step 2
When importing the CSV file into Reckon One, I configured the import settings as follows;

a) I specified to start my import from row 2 as my CSV file contained header information on row 1. You only want to import transactions rows & exclude any header rows.
b) Mapped the 'date' field to the date column in the CSV.
c) Mapped the 'amount' field to the relevant column in the CSV (for me it's the net column as this is the amount that affects my account balance due to PayPal fee's being subtracted from the gross amount)
d) Mapped the 'reference' field to a column in the CSV (choose the column with the data you want for this)
e) Mapped the 'details' field to a column in the CSV (choose the column with the data you want for this)

Example:



Step 3
Click Import the file after having configured Step 2
(Edited)
Photo of Jennifer Enright

Jennifer Enright

  • 200 Points 100 badge 2x thumb
Because the CSV file downloads credits and beits in one column does it pick up as debits and credits
Photo of Qwerty

Qwerty

  • 7,906 Points 5k badge 2x thumb
If your CSV file uses a single column for both debit & credit amounts (uses positive & negative values) then you use the 'amount' mapping option for that column.

or

If your CSV file uses seperate columns for debit and credit amounts then you use the individual 'Debit' & 'Credit' mapping options for these two columns.

(Edited)
Photo of Jennifer Enright

Jennifer Enright

  • 200 Points 100 badge 2x thumb
Thank you
Photo of Geoff Bryant

Geoff Bryant

  • 804 Points 500 badge 2x thumb
I found that I didn't need to do a manual upload, the details were already there under the allocatedĀ TABĀ 
Photo of Qwerty

Qwerty

  • 7,906 Points 5k badge 2x thumb
Users who use the PayPal payment service feature in R1 may not need to import their PayPal statement as the feature automatically enters their PayPal payments (invoice receipts). However they still might for reconciliation purposes to match off the statement transactions to the transactions already in the book.

Users who track their PayPal account in R1 but don't use the PayPal payment service feature may import a PayPal statement to minise their data entry efforts & just add these transactions to the book directly from the statement import.
Photo of Jennifer Enright

Jennifer Enright

  • 200 Points 100 badge 2x thumb
Does this feature cost extra?
Photo of Qwerty

Qwerty

  • 7,906 Points 5k badge 2x thumb
No it doesn't cost any extra however it's only available if your book has the invoicing module.

See this link for more information on the PayPal feature in Reckon One.
https://community.reckon.com/reckon/topics/reckon-one-enhancements-8-july-2016-47lc0p3w0x5v2
(Edited)
Photo of Jennifer Enright

Jennifer Enright

  • 200 Points 100 badge 2x thumb
Thank you