QuickBooks is accounting software which provides various features to its users. It helps small and medium-sized businesses in performing financial activities such as bookkeeping. QuickBooks was created to use as reporting anomalies. The Accounts Receivable(AR) or Accounts Payable(AP) balances must be shown up on the Cash Basis Balance sheet as A/R AND A/P track open and unpaid bills and invoices. Many companies are utilizing Account Receivable and Account Payable reports on a cash basis. Using transactions that have no effect on A/R or A/P is the only way to ensure that the cash basis reports do not have any anomalies.
QuickBooks has a single source account and one/multiple target accounts. The accounts that are posted could be shown in any transaction by starting the Transaction Journal report. The very first lie of the Transaction Journal Report shows the source account and other successive line shows the target accounts.
Account Receivables Debit Balances
- The open invoice with sales tax if the preferences are set to As of invoice data (accrual basis).
- A check transferred to a customer who was recorded in the amount receivable account although it was not linked to any credit memo.
- A statement charging or an active invoice that has stock parts with it.
- A journal entry that debits account receivable as source account and credits balance sheet as a target account.
- A journal entry that debits account receivables as a target account.
- When you transfer credit from one job to another job for a similar customer before attaching the journal entries to the credit memo for a single position and the invoice for the other position.
Account Receivables Credit Balances
- An invoice along with a transaction that records detention to another current asset account.
- Customer’s payment which is not associated with an invoice.
- A payment associated with a future dated invoice if the report date is coming before the invoice date.
- A credit memo for a customer which is not linked to any invoice or a refund check.
- A refund that is made in account receivable account but not linked to payment or an invoice.
- A journal entry that credits the AR account as a source account and balance sheet as a target account.
- A journal entry that credits AR account as a target account. (e.g., transferring credit to another job)
Account Payables Debit Balances
- A bill from the vendor that credits a retainage payable account to decrease the due amount.
- A check or bill payment check that is not connected to a bill.
- A bill payment check which is connected to a future dated bill while report date is between two dates.
- A journal entry that debits AP account as a target account.
- A journal entry that debits Amount payables as a source account and balance sheet as a target account.
- A credit card charge replacing the amount payables account that is not connected to any bill.
Account Payables Credit Balances
- A bill being made for the inventory part.
- A bill offset to a balance sheet account.
- A journal entry that credits AP account as a source account and balance sheet as a target account.
- A journal entry that credits AP as the target account.
- Example 1: inventory Parts that are included in Open Invoices are being considered in account receivables balance under a CBBS. The amount being shown in the amount receivables account is the amount that is going to be posted to the credit part of the Inventory Asset account. (Account receivable will be treated as a source account and inventory asset account will be treated as target account, and both will be shown in the balance sheet.)
- Example 2: Open bill entered after buying the fixed asset such as office equipment, is going to be shown on amount payables account on a CBBS.
- Example 3: Open bills entered with the Inventory Parts debiting the inventory asset account usually credits account payables.
- Example 4: A usual Journal transaction with an expense account as debit under the first head and amount payables account under the second head as credit is going to be shown on CBBS.
NOTE: you are required to enter the AP account as source account on the credit side in the first head and the expense account as target account on debit side in the second head to reverse the lines. (The transaction will not be shown on a CBBS.)
- Example 5: a usual Journal entry along with an Income account as source account on the initial head on the credit side and amount receivables account as target account on debit side in the successive head will be shown on a CBBS. You may also reverse the lines, and for doing that, you are required to enter the AR account as source account in the debit side on the first head and the Income account as target account on credit side in the second head and then the transaction will not be shown on a CBBS.
Pace 1: IDENTIFICATION OF ROOT CAUSE TRANSACTION
We are going to discuss about some reports which might help you to find root causes transaction:
Open invoice report
- Open the Reports menu, click on Customers & Receivables and then go to the Invoices section.
- You have to tap on the correct date from the Date section in the drop-down list.
- Now you need to click on Customize Report and Advanced.
- Select the As of Report Date option.
- The payments that are appearing on the report had been previously received but might not be applied to any invoice.
Unpaid Bills Report
- Open the Reports menu, go to the Customer & Receivables and then you have to click on the Open invoices option.
- You are required to choose the correct date from the Date option in the drop-down list.
- Please, click on Customize Report and Advance.
- You need to tap on As of Report Date.
- The bills that are appearing on the reports were previously entered. However, it does not apply to any bill.
Customer Transaction Detail Report
- Navigate to the Reports menu, open the Company and Financial section and then you have to click on the Balance Sheet Standard.
- Now go to the Customize Report.
- Open the Display tab to get the Report Basis option and then tap on the Cash.
- In this particular step, you need to remove From date. However, you have to keep in mind that you have to keep the To date.
- Select the Ok button.
- In order to bring up the Transactions consistent with the Account Report.
- Now you need to click on the Customize Report option.
- Go to the Display section and then you are required to eliminate the From date yet you have to keep the To date.
- You may now tap on the Advanced option.
- As the next step, you have to go to the Open Balance/Aging Report Date section.
- Select the OK key.
- You may see Customer option under the Total By tab.
- Navigate to the Filters section and then:
- From the Filter section, go to the Account.
- You will get a drop-down list from which you have to select All Accounts Receivable.
- Click No when you get Include Split Detail pop-up.
- Now you have to open the Filter list again, and then you need to follow this path:
Paid Status > Open > Ok > Memorize
(Click on Memorize only when you desire to save the report to use in future times.)
- Each Non-zero customer subtotal will affect your account receivables balance.
Vendor Transaction Detail Report
- Open the Report section, open the Company & financial section and then click on the Balance Sheet Standard.
- Now you have to choose the Customize Report option.
- Navigate to the Display tab and then click on Cash for Report Basis.
- You are required to eliminate the From date and keep the To date.
- Tap on the Ok button now.
- Move the cursor towards the Account receivable amount in order to bring up the transaction consistent with the Account Report.
- Again, open the Display tab and then you have to abolish the From date though you have to maintain the To date.
- Now you need to click on the Advanced option and then go to the Open Balance/Aging Report Date.
- Move your cursor towards the OK option; click on it.
- Select Vendor option which is present the Total By head.
- Open the Filter section and then perform the following:
- Click on the Account tab in to open the drop-down list
- From the drop-down list, select the All Accounts Payable.
- Tap on the No option when Include Split Detail pops up on your screen.
- Move to the Filter list again and then follow the path that is given below:
Paid Status > Ok > Memorize.
(You can choose Memorize option only in the case where you want to save the report in order to use again in future.)
- All the Non-zero customer subtotal are going to influence your Account payables balance.
PACE 2: RESOLVING THE ROOT CAUSE TRANSACTION MANUALLY
NOTE: You have to make a Back up for the QuickBooks company file, prior to following up these steps.
- You need to modify the Sales Tax Preference after receiving the payment because of which the cash basis option before starting the CBBS.
- In the Receive Payment Window, i.e. account receivables, you are required to link the transactions.
- And then connect the transactions in the Pay Bills Window, i.e. account payables.
- The services which are Non-inventory part and all the other charge items need to be linked to Income and Expense accounts:
- Navigate to Lists and then open Item List.
- Now you have to find any of the Balance Sheet accounts such as assets, liability, or equity which are listed in the Account Section.
- You need to ensure that the items to be included in the asset accounts are composed in an appropriate way. Few items such as sales tax, retainers, etc. are required to be added to asset accounts.
- You are supposed to eliminate transactions having issues, on a temporary basis:
- Keep in memory the active transaction and then pull them out.
- You need to get a print out of Cash basis reports.
- Again, from the Memorized list of transactions, enter the transactions.
- You need to perform the editing of Journal Entries (JEs):
- Alter the account payables and account receivable parts of the Journal entries that are connected to multiple transactions along with balance sheet accounts in different Journal Entries.
- Enter the account receivable as source account in the first line of Journal. The balance of journal entries to an Income and expense account is going to be eliminated from the report. On the other hand, the Journal entries that are balanced to a balance sheet account is going to be on the report.
NOTE: Press CTRL + Insert in order to put one extra head to the General Journal Entry and tap on the CTRL + Delete button in order to eliminate one head from General Journal Entry.
PACE 3: CREATION OF PRECAUTIONARY CHANGES TO PROCEDURES.
NOTE: You are advised to stop the utilisation of Inventory Items in case where you have very few of them.
- Note down Inventory.
- You are required to perform the deactivation of the Inventory Items.
- Again, change then to Non-inventory parts.
You have to ensure that not even a single target locates in the balance sheet accounts if you are using the bills and invoices.
Tracking account receivables and account payables in a separate data file:
- You need to give transaction details that are done on cash basis in the main (or cash) data file.
- Submit only the accrual transactions in the secondary (or accrual) data file.
- You are suggested to eliminate the active accrual transactions. And after this, you are supposed to enter them again as cash transactions in case the cash is paid out or paid in.
QuickBooks Tech Support
We hope that this article will help you the issues regarding AR and AP balances on cash basis balance sheet. Yet you face any difficulty in following up these steps, or you need any kind support, you may contact our ProAdvisors. We have in intellectual and experienced representatives in our ProAccountingXpert’s team of ProAdvisor. We are just a ring apart to provide our services to you. Call us on QuickBooks Support Phone Number +1800-366-1468 toll-free.