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

I need Apply multiple sale Invoices for past years at time and for Related months any help

and we have paid through thirty Party Payment they charges some amount for past years without changes past amount of past can i get guide us
2 Comments 2
Fiat Lux - ASIA
Level 15

I need Apply multiple sale Invoices for past years at time and for Related months any help

You can 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

https://transactionpro.grsm.io/qbo

 

GlinetteC
Moderator

I need Apply multiple sale Invoices for past years at time and for Related months any help

I can guide you through how to apply those payments to your invoices, narayan-bevara-o.

 

You'll have to enter the actual amount paid for the invoice and then create a deposit from that payment where you can deduct the charge as a negative amount. 

 

Let me show you how: 

 

  1. Click + New, select Receive Payment.
  2. Tick the checkbox next to the invoice you would like the payment to be applied.
  3. Select Undeposited funds as the deposit to account.
  4. Choose Save to record the transaction.
  5. Go back to + New, then Bank Deposits. You should see the payment you entered in the Select Existing Payments section at the top.
  6. Place a checkmark to select the payment you want to deposit.
  7. From the Add funds to this deposit section, enter the fee charged to you as a negative amount.
  8. From the Account section, select the Expense account you use to track these fees.
  9. Verify that the deposit amount is correct.
  10. Click Save.

 

You can then categorize and match your transactions in QuickBooks Online.

 

When everything is set, you can reconcile your account to keep your books updated. You can check this article for detailed instructions for the reconciliation process: Reconcile an account in QuickBooks Online.

 

I'll keep an eye out for your reply if there's anything else you want to add about applying for customer payments. I'll be sure to help.