In Accounting and bookkeeping, there are many errors that are done mistakenly. So, that is the “small open balances or credits in the QuickBooks” account that can also happen.
For that here, you are going to have all information regarding the write-off that balances and makes it clear easily.
The symptoms are as follows
• There are many credit balances shown in the opened invoice reports
• In the total column, there you can see the small amounts
• There are many numbers of lines with zero and aged balances in the A/R aging summary.
The Reasons that Cause this Problem are Mentioned below
• The business that is small has to be written off
• In the invoice, the payment has not been applied yet
• The credit that is issued but not yet applied to the invoice.
The Solution to Resolve the Small Open Balances or Credits in QuickBooks
QuickBooks software has a feature of small open balances or small open credits, which lets easily add transactions. The open balance method is the traditional way that QuickBooks records transactions.
Option 1: For fixing the customers payments and credits with CDR that are unapplied
- First of all, click on the Client Data Review Feature
- Now click on the customer’s tab and then select a name from it
- Go to the Invoices and charges tab, click on the payment method to apply it to your invoice
- Then click on the option Auto apply all if you want to apply this method on all the individual payments and the invoices
- Click on the Apply button below
- After that, the transaction turned gray, and then click on the Save option to save all these changes.
Option 2: For reviewing the Accounts Receivable aging summary and open reports of invoices
- In QuickBooks, click on the Reports
- Then click on the option Customers and Receivables
- Now, you have to run the summary of A/R aging and also open the reports of invoice
- After that open the invoices report
- Leave the date set to today as default (It helps you in preventing the writing-off of the later added amount on another date or later in any of the opened customer invoices)
- You have to review this report as it shows all the credits or payments that are not applied to the invoice.
Option 3: For the manual clean-up of the open items without the CDR
Manual or automatic clean-up is required. But the manual clean-up is required often without using CDR or any other tool. If the deposits are directly filled but are not mentioned in the Accounts Receivable then the CDR tool will not help you with this. If the entry of journal entry is directly done into Accounts Receivable (A/R) then the CDR is not assisted.
To do a manual cleaning up the steps are mentioned below-
- Click on the Accounts receivable
- Then open the customer who is appropriate
- In this, the amount you have to leave is Zero
- After that, you have to click on the Discounts and credits
- For further options, click on the Credit or Journal entry for applying to the opened invoice.
Option 4: For writing off the invoices in the Client Review Data
There is a tool for write-off the invoices in the CDR as well that helps you in writing-off the financial charges or statement charges in one window. The steps you have to follow to write off invoices are as follows:-
- First of all, make a list of the invoices that you want to write-off
- Then click on the button Find All
- Now to limit down the list, enter the criteria again and click on the Find all button
- If there are no criteria then you get the full list having all the invoices
- Fill the field Up to with the date then click on the Invoices to write off
- Click on the Select All option to select all the invoices
- You have to specify the terms for write-off
- Click on the Write-off the account option that is mentioned in the list and you can also change the date if you want to
- The class track is filled in the write-off class field if you use class tracking
- After that, click on the option Preview and write off the Selected invoice
- Then a message box appears for the confirmation that shows you all the invoices that you do write-off
- Select the button Write-off to make it done or else click on the Cancel button to get back to the previous window
- Also, mention the terms of write-off
- Click on the account write-off that is required
- Change the date of write-off if needed as the date is the last day of the review period so it is required
- Enter the class for the write-off as it is also necessary.
For writing-off the Small Balances in QuickBooks
If the payment is recorded in the Receive Payments window then it’s easy to write off the balance. For this, the steps are mentioned below:-
- If there are open invoices report, then you have to check that the report has an open balance as you have to double click on it to open it
- After that, click on the option History link to get the history of the transaction
- A dialogue box appears on Transaction History
- In this, click on the button and go to the Customer Payment window
- Then select the Write off the extra amount
- Now click on the button named Save and Close.
For writing off the Vendor Bills
The A/R is increased when you buy something from the vendor so the balances are not equal and it makes the difference. You can do something that helps you in making the balances equal that totally depends on the volume of transactions.
For issuing a credit memo
In this, the amount that is making a difference in the accounts receivable, for that amount makes the credit memo and also issued the credit for the same amount bill. Now check and verify that the credit and credit memo are of the same amount creating the same difference in your balance. With this, the balance net is to be 0 without having any balance in both accounts.
For creating the Deposit or Check
For this, you have to check the lower balances between the Accounts Receivable or Accounts Payable. For the account that has a higher balance amount, the check write-off is created for that to make both balances equal by removing the outstanding amount. The same amount must be there for the deposit and check and the balance remaining in the A/P or A/R must be due or owing from the customer or the vendor. In the end, the balance amount should be shown as 0 in the company.
Above, you get the solution that you have to do for how to resolve small open balances or credits in QuickBooks. The information mentioned above is correct and verified so you don’t need to worry at all.
For more issues or queries you can reach the QuickBooks Consultant customer helpdesk to get all the required solutions for your glitches. You can also connect with the team via email or get instant replies via 24/7 live chat.
Get instant assistance with QuickBooks accounting software. Our QuickBooks experts are available 24x7 and resolve issues within minimum turnaround time. We support both US & Canada Editions of QuickBooks Software.We get help you on these QuickBooks accounting topics
- Import and Export
- Data Conversion
- Payment Solutions
- Upgrade & Update
- Payroll Solutions
- Data Recovery and many more.