Articles
HOW ONE CAN FIND SPECIFIC TRANSACTIONS THAT ARE OUT OF BALANCE?
by Shivani Bhati Entertainment News Have a look at given steps:PART 1:
1. FOR CUSTOMER REPORT:-
- To find out this, go to Report menu in your QB software, choose Custom Report option and then select Transaction detail
- As you choose Transaction Detail, a window will appear in front of you saying Modify Reports, then you have to select the Customised report
- After this, go to the Display tab and move on with the instructions given:
- Now, you need to modify Report Basis either to Cash or Accrual
- Now, put data in 'From and To option', you have to fill in there by the time your sheets went out of order when they were wrong
- Set the Total By option to Customer
- After this, go to the Filter Tab option and follow the guidelines:
- You will see Filters list, there you have to select 'Transaction Type'
- After opening Transaction Type, select Multiple Transactions in filter detail information. After then, choose Invoice, Credit Memo, and Payment
- At last, select OK
If after performing these steps, you get Date and Customer having non-zero subtotal, then that's the customer who has damaged the transaction. Suppose, if you get total as non-zero but not that amount and date by which B/S were out of date, you are
required to add an Another Transaction to the Filter type. More often, you are required to add some journal entries and checks also.
2. FOR VENDOR REPORT:-
- In Quickbooks, go to Reports menu, open Custom Reports and choose Transaction Detail from it
- As you open Transaction Detail modify a report, a window will appear. From there, you need to select Customise Report
- Go to Display Tab and move as per guidelines are given
- On the Display tab, you need to set Report basis either to CASH or ACCRUAL, whatever you think is wrong
- Now, put the exact date, your B/S was gone wrong in FROM and TO option
- Set the total by to VENDOR
- After following these steps, go to Filter tab and follow the instructions given
- On Filter list, select TRANSACTION TYPE
- On Filter Details, select MULTIPLE TRANSACTIONS and then you are required to select BILL, BILLS CREDIT & BILL PAYMENT
- Finally, press OK
If, the total received by you is the amount by which your balance went wrong and for that particular date, you have to find out who has non-zero subtotal and that's the vendor who has damaged the balance If after following these steps, you get the total that is non-zero but not that amount by which your
b/s (Balance Sheet) gone wrong, you need to add Another Transaction to filter type.
3. FOR JOURNAL REPORT:-
- In your Quickbooks, choose Accountant and Taxes from the Reports menu, and then go to Journal
- Now, select Customise Report
- Go to Display Tab, follow the instructions:
- Set the Report Basis either to CASH or ACCRUAL, which is wrong according to you
- Set option of From and To with the actual date your B/S were going wrong
- At last, press OK
4. POINT TO CONSIDER:
In case, a total of Debit and Credit mismatch, it means you have got the correct date when your b/s went wrong. You are required to search the transaction showing mismatch and delete and recreate what is essential.
FOR OTHER TRANSACTIONS:-
- Open Report menu in your Quickbooks. Choose Custom Report option from there and then go to Transaction Detail
- A modify report window will appear in front of you, select Customise Report there
- Go to Display Tab and follow the guidelines given:
- Now, set Report Basis to Cash
- After this, open a drop down menu for date and select ALL
- Now, set the Total By to Cash
- Add Item Column
- Press OK
- Scroll down to the end of your report, if last of all group of the transaction has title NO ACCNT and the column is also blank, we can conclude that these transactions have not assigned yet. And you need to perform given
steps:
i) Choose Item List from List menu
ii) After opening Item List, right click on the item and then select Edit Item
iii) Change Account and then press OK
iv) Again open Edit Item menu
v) Modify it and set Account bat to original A/C and then hit OK
vi) Simply repeat step (v)for each single transaction on the following report that doesn't contain any
account.
Still, you have any query about Quickbooks so you can call us our Quickbooks Support toll-free number 1-866-292-4631 and visit us on Quickbooks POS.
Sponsor Ads
About Shivani Bhati 
Entertainment News
53 connections, 2 recommendations, 211 honor points.Joined APSense since, April 26th, 2017, From Delhi, India.
Created on Jul 21st 2018 04:37. Viewed 360 times.
Comments
No comment, be the first to comment.
