Skip to main content
December 4, 2023
Solved

Clearing Old Receivables and Payables in QB without Impacting Financials

  • December 4, 2023
  • 2 replies
  • 0 views

I am facing an issue with old receivables and payables that remain uncleared, causing them to linger on my unpaid bills and open invoices. Is there a way to clean this up without impacting my financial results? These are items from 4 to 5 years ago.

Best answer by AldritchM

Hi there, @Mark343.

 

Allow me to help you close them out and clear your accounts payables and receivables. You can create a general journal entry to write off the amount. Make sure to consult your accounting professional before trying any of these options.

 

Here's how:

Start with opening a Journal:

 

  1. From the Company menu, select Make General Journal Entries.
  2. In the Make General Journal Entries window, change the date and fill in the entry number if necessary.

 

For a customer with an overpayment:

 

  1. Choose the Account field and select Accounts Receivable from the dropdown list.
  2. Input the amount under the Debit column, tab to the Name column, and choose a Customer Name from the dropdown list.
  3. In the next line, choose the offset account and input the amount under the Credit column. The offset account is usually an Expense account.
  4. Select Save and Close.

 

For suppliers with overpayment:

 

  1. Choose the Account field and select Accounts Payable from the dropdown list.
  2. Input the amount under the Credit column, tab to the Name column, and Choose the supplier name from the dropdown list.
  3. In the next line, choose the offset account and enter the amount under the Debit column.
  4. Select Save and Close.

 

For more info, here's an article on ways to remove the amounts: Write off customer and supplier balances.

 

Additionally, I'd like to leave this article to know how to enter a prior balance for a customer that owes you money or a supplier you need to pay: Manage outstanding balances for customers and suppliers in QuickBooks Online.

 

If you need more guidance about managing your clearing off your accounts receivables and payables or other QuickBooks products, don't hesitate to reply. I'm always around to help!

 

 

2 replies

AldritchM
AldritchMAnswer
December 4, 2023

Hi there, @Mark343.

 

Allow me to help you close them out and clear your accounts payables and receivables. You can create a general journal entry to write off the amount. Make sure to consult your accounting professional before trying any of these options.

 

Here's how:

Start with opening a Journal:

 

  1. From the Company menu, select Make General Journal Entries.
  2. In the Make General Journal Entries window, change the date and fill in the entry number if necessary.

 

For a customer with an overpayment:

 

  1. Choose the Account field and select Accounts Receivable from the dropdown list.
  2. Input the amount under the Debit column, tab to the Name column, and choose a Customer Name from the dropdown list.
  3. In the next line, choose the offset account and input the amount under the Credit column. The offset account is usually an Expense account.
  4. Select Save and Close.

 

For suppliers with overpayment:

 

  1. Choose the Account field and select Accounts Payable from the dropdown list.
  2. Input the amount under the Credit column, tab to the Name column, and Choose the supplier name from the dropdown list.
  3. In the next line, choose the offset account and enter the amount under the Debit column.
  4. Select Save and Close.

 

For more info, here's an article on ways to remove the amounts: Write off customer and supplier balances.

 

Additionally, I'd like to leave this article to know how to enter a prior balance for a customer that owes you money or a supplier you need to pay: Manage outstanding balances for customers and suppliers in QuickBooks Online.

 

If you need more guidance about managing your clearing off your accounts receivables and payables or other QuickBooks products, don't hesitate to reply. I'm always around to help!

 

 

January 22, 2024

I have a balance in my accounts payable for year end that is not associated with any vendor balances.  I am thinking that it was erroneously carried forward without ever being reconciled.  I know I have 1 outstanding A/P at EOY, but the rest is not associated with a vendor.  What would be the correct accounting/Journal Entry I would need to do to correct this at EOY 2023 so that the balance of my A/P carries forward into TY 2024 correctly.  Thank you for your feedback.

January 22, 2024

Nevermind.  I have found the discrepancy and it isnt a discrepancy at all.  Just bills from December that were input into QBO but not paid until January 2024.  I originally ran the report for all time.  Thank you for your help.

Rainflurry
December 4, 2023

@Mark343 

 

You're not on cash basis, correct?  If you're on cash basis, they can be zeroed out and that will not impact the previous year's financials.  

 

If you're on accrual basis, you will need to create entries in 2023 that clear the A/R and A/P balances.  Are these uncollectible accounts (positive/debit A/R balances) and old vendor credits (negative/debit A/P balances) or what?