Reconciling Cash Deposits

I am working on a journal entry in Quickbooks to record my cash sales but it is very difficult to find all the information needed.  I get the cash received from the drawer report, but this never balances with my sales report.  If I run a sales report for cash sales(Category Sales>Advanced Options>Payment Method), it does not include cash sales/receipts from Split Transactions or Gift Cards sold and paid for with cash.  There also does not seem to be an easy way to run a report to get this info and I have been going to the transaction level detail to pull up the receipts to find out how they are being paid.  I really would like a sales report to show all cash sales including gift cards and split transactions.  Anyone know an easy way to get this necessary information?

1,113 Views
Message 1 of 2
Report
1 REPLY 1

Your Category sales report does not refelct TAX, that and make sure you are looking at NET and not Gross.

 

If all you want is a cash report there is a "Payments Method" Report.  This will show you all Payment methods and totals, which is the total sales too.   There is no report that will show "split transactions", it just shows where the money when for the transaction.

 

Hope this helps

1,110 Views
Message 2 of 2
Report