Enter past sales and A/R, as well as past vendor and A/P transactions, before entering any past checking or bank transactions. QuickBooks Online updates your bank balance as you enter payments received from customers and payments to vendors.
There are two ways to enter sales and A/R transactions. Both methods ensure accurate reporting.
As you enter your A/P transactions, enter the dates of the original transactions. Enter your historical bill transactions in the following order:
Entering Banking Transactions
I hope this helps!
Hi! I’m also trying to enter previous statements into qbo (ten years worth to be specific) so majority
of it will be by manual entry. I’ve already linked the bank accounts so there is an opening balance and the last three months have reconciled. How to go about entering (for example) my bank statements from 2012? I don’t want to have an error with the opening balance but unless I’m missing a step- I’m unable to change the opening balance. Hope this makes sense. Thank you.
Thanks for visiting the Community, @cyndithompson.
It’s my pleasure to lend a hand with emailing customer statements in QuickBooks Online.
With QBO, you can create and email statements for single or multiple customers. Here's how:
For a single customer:
1. Go to the Sales menu and select Customers.
2. Choose the customer you want to create a statement for.
3. From the Actions drop-down, select Create Statement.
4. Select the type of statement you want to create.
5. Set the Statement Date, Start Date, and End Date.
6. Click Apply.
7. Hit Save and send.
For multiple customers:
1. Go to the Plus icon and select Statement.
2. Select the type of statement you want to create.
3. Set the Statement Date, Customer Balance Status, Start Date, and End Date.
4. Click Apply.
5. Choose the recipients.
6. Hit Save and send.
Here’s an article that tackles more about this: How to create and manage statements.
That should get you pointed in the right direction. Please let me know if you have any questions about statements, I’ll be more than happy to answer them for you. Thanks for dropping by and take care!
If you need transactions imported more than 90 days back, you will need to contact your bank to get a CSV (comma separated values) spreadsheet from your bank for the affected time period. You may need to pay your bank a fee for this unless there is an extenuating circumstance, such as the bank feed coming into Quickbooks reversed for an extended period of time. Otherwise, everything needs to be entered manually. The CSV file can be imported into Quickbooks.
On many banking sites or credit card sites you can download transactions that are older than 3 months and import them into QuickBooks.
I usually use transaction pro importer for large amounts of data ($19.99/mo[can do 1 time purchases]) and always do a small test first of like 5 transactions since unlike qb desktop, you can't try things in a sample co. file.