Can't use Manual upload CSV. Format

  • 1
  • Question
  • Updated 2 months ago
  • Answered
I have tried a few time to upload the CSV format bank statement to Reckon One.
Could you please help to fix it? Thanks.
Photo of Rachel Zhong

Rachel Zhong

  • 262 Points 250 badge 2x thumb
  • frustrated

Posted 3 months ago

  • 1
Photo of Rav

Rav, Community Manager

  • 63,114 Points 50k badge 2x thumb
What is happening when you try to perform an upload Rachel?

Are you getting an error message? Which browser are you using? Does the same issue occur on a different browser as well?
Photo of Rachel Zhong

Rachel Zhong

  • 262 Points 250 badge 2x thumb
Hi Rav,

There is no error message turning up. Click the manual upload button and waiting as normal. Then there is nothing here yet... status of completed is NO. I use firefox and chrome to upload, both browser got same result. Any ideas? Thanks.
Rachel
Photo of John G

John G, Information Support Analyst

  • 27,300 Points 20k badge 2x thumb
Hi Rachel,

Check your actions against the video guide:   Reckon One – Import a CSV Bank Statement
 

regards,
John
Photo of Skye McClymont

Skye McClymont

  • 120 Points 100 badge 2x thumb
Hello, tacking on to this thread in relation to manual uploads.  I did a manual upload, selected the DR & CR columns, but it seems all of the transactions have come in as 'money in' amounts, instead of some debits and some credits as per my statement.  Can I remove the uploaded items (all of, or just the incorrect ones) and then can I continue to reconcile with no manual upload and no automatic upload?  Thanks.
Photo of Shisir

Shisir, Employee

  • 3,048 Points 3k badge 2x thumb

Hi Skye

Normally the bank will provide the CSV file with a single column for the amount, where it indicates the ‘Money Out’ transactions as negative balance (by inserting the ‘Minus’ symbol in front) and ‘Money In’ transactions will show as positive amount, (with no ‘Plus’ symbol in front).

When you upload the CSV file you will need to map this amount column to the ‘Amount’ header. Therefore, when you import it further, Reckon One will automatically, import them correctly and allocate it as payment or receipt, accordingly.

i.e All the negative amount will import as ‘Money out’ transactions and you will be able to allocate it as allocate payment transactions

All the positive amount will import as ‘Money in’ transactions, therefore allowing you to record it as ‘Allocate receipt’.

 

Further, as you wish to delete the incorrect import, could you please follow through this instruction on how to delete all the incorrect upload transactions in bulk, and try uploading it again with the correct mapping as explained above.

Hope this helps.

Please let me know how it goes.

Regards

Shisir
Photo of Skye McClymont

Skye McClymont

  • 120 Points 100 badge 2x thumb
Thank you Shisir, that worked to delete the uploaded transactions very easily.  Going to try an upload for the next month's transactions and finish the current reconciliation that I'm working on without an upload.  If I have any more troubles I will be sure to post back to this thread.  Thanks for the help.

Photo of Skye McClymont

Skye McClymont

  • 120 Points 100 badge 2x thumb
Ok, worked out what happened.  Although the transactions were in debit and credit columns on the export file, and I marked them as debit and credit when I uploaded them, the amounts in the debit column had a minus sign in front.  So clever Reckon shifted them over to the credit side.  Needed to do a bit of editing in my csv file before upload, but I now have it right. 
Photo of Shisir

Shisir, Employee

  • 3,048 Points 3k badge 2x thumb
Thanks for the Update Skye, and glad you have figured it out.

Just out of curiosity, you mentioned that in your CSV file, you have Dr and Cr amount, was it from Paypal feed by any chance? Cause, I know that PayPal exports have that such fields on their export.

On my test, for ANZ bank, they had a single column for the amount with positive and negative amounts in it, and Reckon  One will automatically recognise -ve amount as Money Out type of transactions.

Regards

Shisir