I downloaded my monthly data last year for HST purposes (Ontario) and my bookkeeper excludes US buyers as I don't remit HST on their purchases.
This year I cannot seem to sorta the data from the monthly downloads into Canadian buyers vs US buyers, am I missing something?
Thanks,
Nancy
Sort the spreadsheet by the column that shows the country.
Sort the spreadsheet by the column that shows the country.
They are not there... there's no country anymore... All I can figure is to sort by HST in column I. I just download the "Generate CVS" file under each month correct? I am not seeing country, columns A to I.
I see, Date, Type, Title, Info, Amount, Currency, Fees & Taxes (all say CAD), Net, and Tax Details (under Tax Details I see who I collected HST under)
DUH, I was in the wrong area, I now found the correct data in Download Shop Data. sorry and thanks for answering!!