By Accounting Solutions | June 30, 2017 at 01:48 PM EDT | No Comments
Getting old data into a new QBO
I'm becoming an expert in importing transactions into QuickBooks Online edition (QBO).
QBO Banking "Upload" command imports CSV (many bank downloads, or Excel) , QFX (designed for Quicken), QBO, and OFX (a generic financial format). These will come into the Banking feed, ready for your review.
But what if you've only got access to a PDF, or worse yet, a paper bank statement? I just did this for a client. He had statements from January to June 2015. I moved them from PDF into the Banking Feed, ready for his review. In the Banking screen the existing Rules are being applied to speed data entry (both user-created and behind-the-scenes rules).
I use tools from MoneyThumb software for importing from bank statements. For other types of transactions like invoices or bills there are tools like Transaction Pro Importer that import from Excel, Access, text, OBDC and other formats.
Need help? I'll do projects like this for my clients, businesses that might become my client, bookkeepers, accountants, IT and tax preparers; nationwide but especially in a radius around Albany in Upstate NY and western Mass. Thanks to Hector Garcia of dataentryus.com for introducing me to MoneyThumb...if I can't help you, he's the man.
Nearly 400 transactions imported and ready for review. Happy client, happy life!