Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months* Ends 11/30
Buy nowI've recently connected my Bank Account - which contains both my business and personal accounts - such as personal checking and home mortgage.
My question is this: How to I enter all of my old invoices (from before I bought QBO) as income into QuickBooks Online?
Also, I created a test invoice sent to my own email - and would like to delete this - since this adds income that isn't real.
Thanks!
You can prepare your data as Sales Receipt with the following template
| RefNumber | Customer | TxnDate | ShipDate | ShipMethodName | TrackingNum | Location | Class | BankAccount | PaymentMethod | PaymentRefNumber | BillAddrLine1 | BillAddrLine2 | BillAddrLine3 | BillAddrLine4 | BillAddrCity | BillAddrState | BillAddrPostalCode | BillAddrCountry | ShipAddrLine1 | ShipAddrLine2 | ShipAddrLine3 | ShipAddrLine4 | ShipAddrCity | ShipAddrState | ShipAddrPostalCode | ShipAddrCountry | PrivateNote | Msg | Currency | ExchangeRate | BillEmail | ToBePrinted | ToBeEmailed | ShipAmt | ShipItem | TipAmt | DiscountAmt | DiscountRate | TaxRate | TaxAmt | DiscountTaxable | LineServiceDate | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineClass | LineTaxable |
| 101 | Janice Johnson | 01/10/2020 | Checking | Check | 20013 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | [email address removed] | N | Y | 0.02 | Y | Leather Case | Leather Case | 2 | 10 | TAX | ||||||||||||||||||||||
| 101 | Janice Johnson | 01/10/2020 | Checking | Check | 20013 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | [email address removed] | N | Y | 0.02 | Y | Gift Cards | Gift Cards | 2 | 5 | TAX | ||||||||||||||||||||||
| 102 | Leonard Walker Inc | 01/10/2020 | Checking | Cash | paid cash | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | [email address removed] | Y | N | Y | Handhelds | Portable Game Player | 1 | 100 | TAX | ||||||||||||||||||||||||||
| 102 | Leonard Walker Inc | 01/10/2020 | Checking | Cash | paid cash | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | [email address removed] | Y | N | Y | Software | 1 Year Warranty | 1 | 25 | TAX | ||||||||||||||||||||||||||
| 102 | Leonard Walker Inc | 01/10/2020 | Checking | Cash | paid cash | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | [email address removed] | Y | N | Y | Extended Warranty | 1 Year Extended Warranty | 1 | 5 | TAX | ||||||||||||||||||||||||||
| 103 | Lisa Smith | 01/10/2020 | Checking | Check | 4591 | 19 Jerico Drive | Bensalem | PA | 84256 | 19 Jerico Drive | Bensalem | PA | 84256 | We appreciate your business! | [email address removed] | N | Y | Gift Certificate | $50 Gift Certificate | 1 | 50 | NON |
then utilize an importer tool
https://transactionpro.grsm.io/qbo
Hi there, @Peter Vaughn.
I'm here to help with inputting your old invoices into QuickBooks Online.
Some banks will automatically import your transactions within 90 days or beyond. If there are invoices that were not included and that are part of your bank statement, you can either manually enter the invoices or enter them one at a time.
Let's make sure that we enter the correct dates when recording old invoices. From the + New button, click on the Invoice.
You can check out this link to learn more about recording invoice payment: Recording invoice payments in QuickBooks Online
Furthermore, if these invoices are not part of your bank statement, you can create a journal entry affecting the account receivables. Here's how:
Since invoices can impact multiple areas, such as reporting and sales tax, you may wish to consult with your accountant to ensure the best path for your business.
I'm including some links that I believe may be helpful for you:
Don't hesitate to let me know if you have any concerns about adding the invoice. I am cheering for your continued success.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here