cancel
Showing results for 
Search instead for 
Did you mean: 
Mark343
Level 1

Clearing Old Receivables and Payables in QB without Impacting Financials

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.

Solved
Best answer December 04, 2023

Best Answers
AldritchM
QuickBooks Team

Clearing Old Receivables and Payables in QB without Impacting Financials

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!

 

 

View solution in original post

4 Comments 4
AldritchM
QuickBooks Team

Clearing Old Receivables and Payables in QB without Impacting Financials

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!

 

 

Rainflurry
Level 13

Clearing Old Receivables and Payables in QB without Impacting Financials

@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?

Tina4311
Level 1

Clearing Old Receivables and Payables in QB without Impacting Financials

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.

Tina4311
Level 1

Clearing Old Receivables and Payables in QB without Impacting Financials

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.

Need to get in touch?

Contact us