Ok, so I’ve just come across something interesting which I’m trying to get my head around. After ending a work period, we go to check work period report to give us a sum of what we made on that day, then I went to look at the “Cash Transaction Report” and I see the cash and credit card accounts to match the work period report amount, but then the TOTAL at the bottom doesn’t. It’s off by like $178.9.
Initially I thought the extra could be the Tax total., but then in work period report the total amount minus tax is the ticket total… the total amount below tax amount is the actual amount which matches the cash transaction account, therefore I came to conclusion that It cannot be the tax extra.
Anyone have an idea about why it’s not matching?
Here’s the work period report screenshot
Below is the cash transaction Report
The other payment account is only Voucher- which after looking at all sales in the database and in the account and ticket sections, I can’t see anything relating to other accounts.hmmm
EDIT:
here is the screenshot below of accounts page.
So I tried to look at the database again, and edited account entity page to view each payment account seperately to get a better reading, but It still does not show anything out of the ordinary. Doesn’t show anything that isn’t supposed to be there, I was wondering if clearing the database transactions could give me a better insight. Any thoughts?
So what this means is you have a running balance from somewhere at some point. We can spend a year trying to find out where the running balance came from or we can just fix it. To fix it you need to create an Account Type and an Account called Corrections and use it to make your balance in your Payment accounts equal 0. So transfer everything from your Cash and your Credit accounts into your Corrections account.
Your using Customer Cash payment transaction type for your Tax. This explains the missing money lol. You need to create a new Account Transaction Type for your tax and put it in its own account.
The difference your seeing is your Tax but you dont have an account for it so its just floating out there in your receivables account.
Wow haha that’s news to me. I knew it had something to do with tax but didn’t expect it to be what you found. So first I have to correct it before I create the new tax account , correct?
Yes your right maybe that is what he was asking. Its hard to really understand. Very vague questions in old posts is not a good idea. Be detailed with your questions and try not to resurrect old posts unless you are contributing to them.
