Skip to main content
March 3, 2022
Question

Account overdue status in quickbooks not fixed

  • March 3, 2022
  • 1 reply
  • 0 views

how to fix overdue payment in quickbooks and get the statement for the customer to show correct deposit was made but still show overdue on quickbooks

1 reply

LieraMarie_A
March 3, 2022

Hi there, @Nick007

 

To clarify, is the invoice fully paid but still showing as overdue? The payment may be linked to another invoice or unapplied. 

 

To verify it, follow these steps:

  1. Go to the Sales menu and select Customers.
  2. Select the customer's name.
  3. Under the transactions list, find and select the payment.
  4. Under the Outstanding Transactions section, review which invoice it's applied to. It should have a checkmark beside the invoice. 
    • If it's incorrectly applied to another invoice, uncheck it and mark the correct one.
    • If it's unapplied, select the invoice from the list.
  5. Click Save and close.
  6. Click Yes to confirm.

 

Otherwise, if you created a bank deposit instead of payment, make it as an available credit by following these steps:

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Find the bank you deposited the payment into. Under the Action column, click Account history.
  3. Find and select the deposit.
  4. Click Edit.
  5. In the Received From column, select the customer the deposit was from.
  6. 5. In the Account column, choose Account Receivable.
  7. Click Save and close.
  8. Select the customer's name.

 

Once the deposit entry is updated, apply it as a credit to the invoice.

  1. Select + New.
  2. Select Receive Payment.
  3. Select the Customer from the ▼ dropdown. This displays all open invoices and outstanding credits for your customer.
  4. In the Payment date field, enter the day you received the payment.
  5. In the Outstanding Transactions section, select the invoice you need to mark as paid.
  6. Under Credits, select the deposit.
  7. Select Save and Close.

 

For your reference, check out this link: How to link a bank deposit to an invoice.

 

Lastly, here's how to create a customer statement:

  1. Go to Sales or Get paid & pay and select Customers.
  2. Select the checkboxes for the customers you want to make statements for.
  3. In the Batch actions dropdown, select Create statements.
  4. In the Statement Type dropdown, select the customer statement type:
    • Balance Forward: Lists invoices and payments with outstanding balances for a specific date range.
    • Open Item: Lists all open, unpaid invoices from the last 365 days.
    • Transaction Statement: Lists all transactions for the selected date range.
  5. Select the dates for the statements and the date range.
  6. Review the customer's email addresses.
  7. Select SaveSave and closeSave and send, or Print or Preview.

 

Feel free to post a reply below if you have any other questions about applying payments. I'm always around to help. Stay safe and take care always.