I hear your concern about efficiently matching the payments received to the relevant invoices that had settlement discounts offered, @RBT-05. Let me walk you through the most streamlined process for handling this in QuickBooks Online.
To begin with, you are correct in noticing that there is no direct way to import discount amounts when mapping invoices from Excel.
The key to streamlining this process is to import the full undiscounted totals of all invoices first and then manually apply settlement discounts to each invoice that the customer has taken advantage of. This way, you can efficiently match what was received with what was owed, while still keeping track of the discount amounts in your QuickBooks accounts.
To add a discount to the subtotal on an invoice, here's how:
- Select + New.
- Select Invoice.
- Select Manage to add a discount to the invoice or estimate.
- Select the Payment options dropdown.
- Turn on the Discount setting to add the discount field to your invoice or estimate.
- Fill out your invoice or estimate.
- For the discount, choose $ for a flat discount or % for a percentage discount.
- Select Save.
After you add a discount to the subtotal on an invoice you can now begin to match the payment to the invoice.
Here's how:
- Go to Transactions in the main menu and select Bank Transactions.
- Choose the payment and click on Match.
- Select the discounted invoice and Match.
I've also included a resource to help you review your accounts and ensure they match your bank and credit card statements: Reconcile an account in QuickBooks Online.
Loop me in if you need extra help with this matter. The Community is always open to assistance. Just leave a reply below. Take care!