Calculate collected taxes

[nlavoie]

Hello

I am not great at excel and need help

as I am entering all my 2013 receipts and invoices into quickbooks, I want to duplicate each entry into excel to ensure qb is doing a good job

basically I have four fields

1. Invoices Amount
2. HST Collected

3. Expenses
4. HST Spent


What I want to do is enter the full amounts with HST included in the Invoices Amount and the Expenses cells, at the same time the HST Collected cell would tell me how much HST (13%) was collected on the amount and the HST Spent cell would calculate how much HST was spent in the expenses amount

any easy way to do this?

thanks!

[rcm]

Is this helpful?

[nlavoie]

your sample gave me the idea I needed to do this.. basically, just easy math here lol but sometimes I overthink things..

tell me if you agree with my example

hst.xlsx