Manual upload using Excel

Inthi

Could a hard copy credit card statement be keyed into an Excel file and be uploaded into Reckon One?What type of file should it be saved as in Excel? It seems faster keying into Excel than inputting each transaction separately into Reckon One

John G

Hi Inthi,

Thanks for asking the Reckon Community.

You can export your credit card transactions off your card's website into a CSV or QIF formatted file and then import it through the Manual Import button on the Banking > Bank Accounts > your Credit Card Account's New Transaction button.  

To make it even easier, consider adding the BankData module.  See the factsheet.


regards,
John

Daniel Dyboski-Bryant

Hello,
I am in a situation where I do not have access to .csv statements farther back than 6 months ago, but need to input 12 months of transactions> so, the original question interests me.
"Could a hard copy credit card statement be keyed into an Excel file and be uploaded into Reckon One?"
It would help me considerably.
Kind regards
Daniel

John G

Hi Daniel,

Welcome to the Reckon Community.

Yes you could, but you'll have to save the final version of the file as a CSV file.

Why key into an Excel file first?  Why not key directly into Reckon One?

Or try out something like AutoEntry, a 3rd party add-on to Reckon One:
https://autoentry.com/integration/reckon/


regards,
John

Daniel Dyboski-Bryant

Hi John,
Thank you for your reply. I will key directly into Reckon one. I was just wondering if there was a quicker way. I guess not. It only concerns maybe 30 transactions and after that it can all be manual uploads anyway.
Daniel