Tender type with Tax report

Rob,

I work for a University and the way the accounting works they have seperate accounts for CC vs Cash/check. They need to know how much sales tax to take from each account. I have yet to find a good way to do that in this software.

Thanks

AC

"Rob @ RMS Systems > Unfortunately that can't be done.

I would think the easiest way to do this, would be to get a general figure of how much sales tax is owed, then a general figure of how much money is going in to each tender type, then take a proportional amount of tax from the respective accounts. Why trouble with trying to figure exactly what numbers match when it doesn't matter anyway?

SubTotal: $20.00 Taxes: $0.50 Total: $20.50 Customer pays $5.00 using Credit Card and $15.50 using Cash. The system does not know which items on the invoice the $5.00 paid for or the $15.50 paid for. All it knows is that Credit Card was X amount and Cash was Y amount.

In a perfect world where all items where taxed and every transaction was paid by only one tender type you could do some reverse calculation to find out the amount of taxes paid by each tender type. But 99.999% of the time that is just not feasible and you will end up with a variance.

What the accounting department needs to do is get in their heads that Taxes have nothing to do with Tender Types.

I agree with Matt. When the state comes looking for the tax you owe them, they don't care how much tax you colleced, all they care about is how much taxable sales you brought in.

If this is truely something you need, we may be able to work something out for you, but it would not be an RMS Report, it would have to be a stand-alone application/report. If interested, drop me an email and we can discuss the details.