Checking a trial balance against the tax grouping before import
UltraTax CS will not take an account number longer than twelve characters, and when truncation drops two accounts into the same tax grouping one of them simply does not arrive. A balance carried to more places than the field holds fails the same quiet way. Meanwhile the client opened accounts in September and renamed others, so the mapping that worked last year no longer covers the chart. Running the import rules against the current chart first turns a wrong number that still computes into a short list of accounts carrying no tax code.
Everything is finished and the return still cannot be filed, because the signature authorisation has not come back.
The trial balance is the centre of this work, and most of the repeated labour is getting source material into a shape the trial balance can accept. Statements arrive as PDFs, receipts arrive as photographs, and bank data arrives through an aggregator that authenticates against a bank which changes its login flow without notice.
- UltraTax CS
- CCH Axcess
- QuickBooks Online
- Excel
When this is the wrong thing to build
Pick something else if the return is built from a trial balance that gets retyped by hand anyway, or the entity is simple enough that the whole chart fits on one screen. This check earns its keep on multi entity work where the chart moves between years and nobody owns the mapping.
The constraint that shapes it
Tax return information is governed by a statute that makes disclosure or use outside preparation a criminal matter, with a parallel civil penalty, and consent has to be obtained in a prescribed form naming the recipient and the purpose. More on how this sector works.
Run the rules of the other side first, so the submission does not come back. Read what this shape is, or start from one of these.
- Counting the clock that public marketing starts on a listing
- Checking for a signed buyer agreement before a tour is confirmed
- Catching a filing rejection before the clerk does
- Catching the invoice lines an e-billing gate will reject
- Checking that a technician may legally take the call
- Filing a backflow test report the purveyor will accept
- Why did some accounts not import into UltraTax from the trial balance?
- How do I find accounts with no tax code before running a return?
- What happens when two accounts map to the same tax grouping?
- Why does a trial balance import drop long account numbers?
- How do I catch a chart of accounts change before tax mapping breaks?
Back to accounting and bookkeeping, or see how this is priced and scoped.