Excerpt:
Journal Entries (JEs) in QuickBooks should be used only as a last resort for advanced financial adjustments, specifically requiring expert knowledge of debits and credits. When adjusting Accounts Receivable (A/R) or Accounts Payable (A/P), every JE line must be linked to a specific Customer or Vendor name to maintain the critical integrity between the general ledger and subsidiary reports, such as the A/R Aging Summary . Failing to link the name results in financial mismatches that severely complicate reconciliation and audits. While routine transactions like billing and payments should use QuickBooks' built-in forms, JEs are necessary for complex tasks such as writing off bad debt, clearing balances between vendors and customers, and making year-end reversing entries under the guidance of an accountant.
Highlights (Key Facts & Solutions)
Journal entries are the last resort for entering transactions. They allow you to move money between accounts and force your books to balance in a specific way. Use them only if you understand accounting or you’re following the advice of your accountant. You may also have a good understanding of debits and credits.
When adding Accounts Receivable (A/P) or Accounts Payable (A/R) for any line in a Journal entry, you must specify a Customer or Vendor name. Currently, the ability to save the transaction without entering a name is unavailable. This is working as design.
Here are a few reasons to create a journal entry:
If you decide to create a journal entry, you need to enter a date of the end of the time period, and set it to reverse on the following day. For invoices, the journal entry debits the account affected by the invoice and credits accounts receivable while for bill entries, it credits the asset account and debits accounts payable.
Warning: It is important to consult an accountant before trying to correct these accounts with a journal entry.
Note: If you’re splitting this over several customer accounts, change the amount to reflect a single customer’s sales tax.
The journal entry is now created.
Note: For offsetting accounts payable or vendor balances, the Credit account type is usually expense or liability. But it’s really important to consult with an accountant. Same with accounts receivable adjustment.
The journal entry is now created.
The clearing process is used for Accounts Payable vendors that are also Accounts Receivable customers. You can apply the Accounts Receivable balances automatically or individually to the Accounts Payable balance.
After the clearing process is completed for a vendor/customer, transactions are recorded in both Accounts Payable and Accounts Receivable.
Warning: If you link multiple customers to a single vendor, you must verify that the amount being cleared from the customer to Accounts Payable does not exceed the vendor’s balance, or the vendor’s account may have a negative balance.
The clearing process applies the Accounts Payable balance to the Accounts Receivable open invoice balance; it clears the oldest invoices in the account first and applies the Accounts Payable balance until it is zero. This process creates payments in Accounts Receivable with a check number of CLEARING.
You can create a general journal entry to write off the amount. Make sure to consult with your accounting professional before trying any of these options.
Here’s how:
Linking the journal entry to the invoice will help you to reduce the remaining customer balance. But before you can do this, you need to make sure that the affected account of the journal entry is Accounts Receivable. This way, the amount will show how once you apply it to the invoice.
Here’s how:
Clearing old Accounts Receivable (A/R) and Account Payable (A/P) balances can be a little tricky. The most efficient way to clear any payables is to pay it off. Aside from making journal entries, this includes creating a clearing account. The steps are similar to setting up a bank account in your chart of accounts, but without an opening balance.
When you’re ready, you can follow the steps below to clear off those A/P balances:
Create the appropriate journal entry:
Apply the general journal entry to the existing balance:
Below we’ve discussed how to clean up accounts receivables from prior years in both QuickBooks Online and Desktop:
You can create Journal Entry (JE) and then reverse it to clear any accounts receivable in QuickBooks Online. You’ll just have to type a date of the end of the time period and set it to reverse on the following day. But before you proceed, it is suggested to consult with your accountant to ensure you enter the transactions accurately and avoid data messing up with your accounts.
Here’s how:
After this, you’re now ready to reverse it, here’s how:
If you’re seeing customers with net zero balances, it is usually caused by an invoice that’s not linked to payment or credit.
To apply for the credit, here’s how:
However, if no payments aren’t showing, you’ll need to record them as bad debt and write them off.
Here’s how to add an expense account to track the bad debt:
Once done, you can start over to close out the unpaid invoice.
Accounts Payable (A/P) and Accounts Receivable (A/R) management is crucial for maintaining accurate financial records and ensuring smooth cash flow.
Here are best practices for managing A/P and A/R, particularly focusing on the proper use of journal entries:
Use the “Enter Bills” feature to record vendor invoices and the “Pay Bills” feature to track payments. QuickBooks automatically creates the necessary journal entries and helps to reduce errors.
Enter vendor terms (e.g., Net 30) when creating or editing vendor profiles. Also, track early payment discounts and apply them correctly in the “Pay Bills” screen to reduce payment amounts.
Set up recurring bills for fixed expenses (e.g., rent, utilities) to ensure timely recording and payment.
Use the A/P Aging Summary report to monitor outstanding balances and avoid late payments. Plus, cross-check A/P balances in reports with vendor statements to ensure accuracy.
You can use the “Create Invoices” and “Receive Payments” features instead of manual journal entries to track sales and payments.
Set up recurring invoices for customers with regular billing cycles to save time and ensure consistent cash flow.
Make use of the A/R Aging Summary report to identify overdue invoices and follow up with customers promptly.
Credit Memos: Move to Customers > Create Credit Memos/Refunds and then enter details for returns or price adjustments. QuickBooks adjusts A/R automatically.
Write-Offs: Browse the Receive Payments screen to zero out the invoice and then apply the remaining balance to a bad debt expense account.
QuickBooks is a database-driven accounting system, not just a simple ledger. A/R and A/P are control accounts that hold a total balance, but the underlying detail is stored in subsidiary ledgers (the Customer and Vendor centers).
The standard logic for writing off or adjusting a receivable balance involves reducing the asset (A/R) and moving the amount to an appropriate expense account.
The entry requires two balancing lines:
The risk is creating an imbalance between the core financial reports, which leads to major audit and reporting headaches.
The clearing process addresses a specific, complex scenario where a business both buys from and sells to the same entity (a customer that is also a vendor). This is often done via two separate transactions using a temporary clearing account, as QuickBooks strictly prohibits using A/R and A/P in the same transaction.
Journal Entries bypass QuickBooks’ automated controls for sales tax, inventory, and customer statements, increasing the likelihood of errors and complicating reporting.
A reversing Journal Entry is a standard accrual accounting technique used to temporarily book an expense or liability and then immediately undo it in the next accounting period.
Writing off a vendor overpayment involves clearing the liability balance that represents the overage and moving that amount to a non-operating income account, which reflects the small gain to the company.