cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
tjconsultants10-
Level 1

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

 
10 Comments 10
AileneA
QuickBooks Team

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

Hi there, tjconsultants10-. 

 

Thank you for reaching out to the Community. Yes, you can import past paid invoices in the system. However, we're unable to mark paid invoices without receiving payments. To import invoices in QuickBooks Online, you can refer to this article: Import multiple invoices at once

 

Also, I am adding additional reference on how to record invoice payment in QuickBooks Online

  

Fill me in if you need anything else. I'll be more than happy to help you. Have a lovely day!

Fiat Lux - ASIA
Level 15

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

@tjconsultants10- 

You may utilize an importer tool to import data as Invoices and Receive Payments.

https://transactionpro.grsm.io/qbo

 

mamaheather2020
Level 1

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

So....am I understanding correctly? I have to go back and manually "receive payment" for the 1,064 invoices that I need to import going back to 2017?

GlinetteC
Moderator

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

Thanks for following this thread, mamaheather2020. I'm here to share additional information about importing in QuickBooks Online.

 

When importing invoices into the system, this will not include the payments. You'll have to record them manually to close the invoices. 

 

To receive payments:

 

  1. Click on the + New button at the top of the left menu bar.
  2. Select Receive payment.
  3. Enter the necessary required fields.
  4. Click on Save, or Save and close.

 

You can check this reference for additional details: Record invoice payments in QuickBooks Online.

 

Need help personalising your invoices? Here's a link for guidance: Customise invoices, quotes, or sales receipts in QBO.

 

You can always get back to this thread if you have other questions. I'll be glad to lend a hand.

Fiat Lux - ASIA
Level 15

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

@mamaheather2020 

You can export your Invoices data to XLS and modify them as 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://get.transactionpro.com/qbo

 

MegnaHoffman
Level 1

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

Is there still no resolution for this issue years later?

JamesAndrewM
QuickBooks Team

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

Hello there,

 

Currently, we can import past paid invoices into QuickBooks Online. However, you'll have to receive payments for each invoice manually.

 

As a workaround, you can batch-record invoice payments for specific customers. I'll show you how:

 

  1. Go to Sales and select Invoices.
  2. Choose an invoice of a customer and click Receive payment.


     
  3. On the Receive Payment page, scroll down to the Outstanding Transactions. Look for the imported invoices and put each checkmark on the check box.


     
  4. Click Save and Close.

 

 

You may visit these links to guide you on how to categorize your transactions and reconcile your account flawlessly:

 

 

The Community always welcomes you for further inquiries about transactions. Have a great day ahead!

dante2023
Level 1

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

no import payment options???? That's unacceptable and makes this product worthless to me.

 

Sorry, But if that is true I will have to find a more usefull product.

 

I have 2542 invoices to import and need to import all of them so this product will be usefull. you are seriously telling me that I would have to receive each manually? It would take less time and money to add a couple features to the custom application that i have. I signed up to this to help streamline data entry. Based on this ONE fact I can see that this product is not suitable for that!

ChristineJoieR
QuickBooks Team

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

Greetings, @dante2023

 

Automating the import of payments in QuickBooks Online can save a significant amount of time and reduce the risk of manual errors, 

 

This feature can be particularly beneficial for businesses that receive a high volume of payments or have complex transactions. Having that said, we can send a request to our product developer. This way, they'll see your suggestion and consider adding it to the next program update.

 

Follow the steps below:

 

  1. Go to the Gear icon.
  2. Under the Profile column, press the Feedback button.
  3. Write your product suggestion, then click Next.

 

Our Product Development team receives your thoughtful comments (QBO) through the feature request link: QuickBooks Online Feature Requests website.

 

On the other hand, there are several third-party applications available that can help automate this process. These applications can connect to your bank or payment processor, download payment data, and import it into QuickBooks Online. We have available third-party apps that can integrate with QuickBooks Online. You'll want to check the list within your account in the Apps tab and press Find Apps. Then look for apps in the Search bar or browse them in the Browse Categories dropdown. You can also visit directly through this link: QuickBooks Apps store.

 

Feel free to reach out anytime if you have more questions or need further assistance with QuickBooks Online. Your success is important, and I'm here to help make your financial management as smooth as possible. Wishing you all the best in your business endeavors!

Fiat Lux - ASIA
Level 15

Can I import past paid invoices onto new system, how do you mark them as paid without having to process payments?

@dante2023 

You can prepare the Receive Payments data in XLS format and use the 3rd party tool as I mentioned earlier as a workaround.