SALE EXTENDED 70% OFF QuickBooks for 3 months*   Ends 12/8

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
Peter Vaughn
Level 2

Setting up QuickBooks Online - Add Old Invoices to QBO

I'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!

 

 

2 Comments 2
Fiat Lux - ASIA
Level 15

Setting up QuickBooks Online - Add Old Invoices to QBO

You can prepare your data as Sales Receipt with the following template

RefNumberCustomerTxnDateShipDateShipMethodNameTrackingNumLocationClassBankAccountPaymentMethodPaymentRefNumberBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgCurrencyExchangeRateBillEmailToBePrintedToBeEmailedShipAmtShipItemTipAmtDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y HandheldsPortable Game Player1100  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y Software1 Year Warranty125  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y Extended Warranty1 Year Extended Warranty15  TAX
103Lisa Smith01/10/2020     CheckingCheck459119 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256  We appreciate your business!  [email address removed]NY         Gift Certificate$50 Gift Certificate150  NON

 

then utilize an importer tool

https://transactionpro.grsm.io/qbo

 

AbegailS_
QuickBooks Team

Setting up QuickBooks Online - Add Old Invoices to 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:

  1. Select + New.
  2. Choose Journal entry.
  3. On the first line, select an account from the Account field. Depending on if you need to debit or credit the account, enter the amount in the correct column.
  4. On the next line, select the other account you're moving money to or from. Depending on if you entered a debit or credit on the first line, enter the same amount in the opposite column.
  5. Check the amounts - you should have the same amount in the Credit column on one line and the Debit column on the other. This means the accounts are in balance.
  6. Enter information in the memo section so you know why you made the journal entry.
  7. Tap Save and new or Save and close.

 

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. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us