We use a POS system that creates a csv file that we import into QBs.
The problem is we can not import into the SALES TAX column.
So when ever we import the revenue ledger we have to edit the JE and set the SALES TAX entry for the HST account so QBs reports the tax to its tax reports. We also have to edit the SALES TAX entry for each sales account and tell QB its a sales account, again so QBs send this info to the sales reports.
We have discovered there is no way to import this information.
So my question is:
Is there a way to set an account (in the chart accounts) so QBs knows that every entry added to the tax account "20500 HST on Sales" has a SALES TAX as "HST-line 103"
and
Is there a way to set an account (in the chart accounts) so QBs knows that every entry added to a Sales account "40000 SALES:40014 Plumbing" has a SALES TAX entry as "E(SALES)"
