cancel
Showing results for 
Search instead for 
Did you mean: 
kas-painting2019
Level 1

I have a invoice app I no longer want to use and want to switch to quick books how do I add alll my old invoices into quickbooks and mark them paid

 
2 Comments 2
FritzF
Moderator

I have a invoice app I no longer want to use and want to switch to quick books how do I add alll my old invoices into quickbooks and mark them paid

Welcome and thanks for visiting the Community, @kas-painting2019.

 

Currently, the option to import invoices You'll want to look for a third-party application that can import invoices in QuickBooks Online (QBO). This way, you'll have an option to import multiple invoices with QuickBooks Online. Just go to the Apps menu at the left pane or through the QuickBooks App Centre.

 

I've got you these resources for additional reference and guide about importing invoices in QBO:

 

 

Please click the Reply button below if you have any other questions or concerns. I'm more than willing to help. Have a good one!

Fiat Lux - ASIA
Level 15

I have a invoice app I no longer want to use and want to switch to quick books how do I add alll my old invoices into quickbooks and mark them paid

@kas-painting2019 

Prepare the Invoice data with the following template

RefNumberCustomerTxnDateDueDateShipDateShipMethodNameTrackingNumSalesTermLocationClassBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgBillEmailBillEmailCcBillEmailBccCurrencyExchangeRateDepositToBePrintedToBeEmailedAllowIPNPaymentAllowOnlineCreditCardPaymentAllowOnlineACHPaymentShipAmtShipItemDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y MP3 PlayerBlue MP3 Player255  TAX
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y HandheldsPortable Game Player1100  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y Software1 Year Warranty125  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y Extended Warranty1 Year Extended Warranty15  TAX
103Lisa Smith01/10/2020    Net 30  19 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256  We appreciate your business!     0NYNNY        Gift Certificate$50 Gift Certificate150  NON

 

and prepare the Receive Payments data with the following template

RefNumberTxnDatePaymentRefNumberCustomerPaymentMethodDepositToAccountInvoiceApplyToLineAmountPrivateNoteCurrencyExchangeRate
128/11/202050245Janice JohnsonCheckChecking101100.00   
228/11/20204908Leonard Walker IncCheckChecking102138.78   
328/11/20204908Lisa SmithCheckChecking103126.50   

 

then utilize an importer tool to proceed.

https://transactionpro.grsm.io/qbo

 

Need to get in touch?

Contact us