Hopefully this is a no-brainer. Note : NOT using Advanced Taxes
1. Set up a tax liability account 'Accrued Sales Taxes' (and corresponding tax control account) where we want all sales taxes to record.
2. version 2009.1:
Wierdness 'A'): If creating a new state tax, you have the option of assigning a liability account. Select 'Accrued State Taxes' and import. Result? NS creates a corresponding state tax liability account automatically (NS support confirmed) -- e.g. import for CA and an account 'State Tax Payable - CA' is created.
Weirdness 'B'): Update an existing state tax (Setup > Use State Tax Tables) and the only choice in the drop down (for example for CA) is 'State Tax Payable - CA' for all tax types. No selection available for 'Accrued State Taxes'.
3. All tax codes (Setup > Tax Codes) [with CA prefix for example] can be set to our specified liability account or 'State Tax Payable - CA', however when new state codes are imported or rates for existing codes are updated, the liability account gets set back to 'State Tax Payable - CA' in all the tax codes for that state (all states get set to 'State Tax Payable - [State]' despite whether set initially on import to 'Accrued State Taxes' (new import only since can't select this account on updates).
4. Wierdest of all!. Going to 'Setup > Tax Types' and editing a particular tax type (e.g. State, County), the only selection in the drop down for Liability/Sales Tax Account (for CA for example) is 'State Tax Payable - CA'. There is no 'Accrued State Taxes' account available as an option even though this is a valid tax control account.
So what is going on? Is this a serious bug? Seems it obviously is given the fact I can't select a valid control account. If I set up a tax control account and specify it for every tax type and for every state tax table import as well, it should stick. Instead, NS sets up an account 'State Tax Payable - [State]' and applies this (and overwrites with this on updates).
Anyone else experiencing similar wierdness? Is there something that may be causing this that I need to check or change?
Thanks.
-Steve