Reporting on Sales Tax Liability



  • Rebecca Ralls

    Here's how I solved this: 

    Using the Declarative Lookup Rollup Summaries tool I put a field on the Billing header that counts how many billing lines have a product where the Tax Type = 'Tax Rate'. (AcctSeed__Product__r.AcctSeed__Accounting_Type__c = 'Tax Rate'). This is to determine whether tax was charged on the billing or not.

    Then on the Billing Line, I made a formula field that determines whether that particular Billing Line is taxable or not: if(AcctSeed__Billing__r.Count_of_Tax_Products__c > 0, CASE(Tax_Type__c, 'Taxable Product', 'Taxable','Tax Rate','Tax Collected','Non-Taxable'),'Non-Taxable')

    Then, using a custom report type based on transactions that pulled the taxable/non-taxable formula field on the billing line into the layout, I was able to create a report that matched the P&L revenue balance and divided out the balance into taxable and non-taxable amounts.

    (The top line item being charged to Vouchers Payable was for a Billing Credit Memo that a customer wanted refunded instead and the organization just selected vouchers payable as the clearing account through which to move the balance).

    Comment actions Permalink
  • Teng Chuan Hiang

    Can AS handle taxes in Singapore and Indonesia? We issue invoices from Singapore and Indonesia and they have different tax policies. What are your recommendations to handle this kind of business setup using AS?

    Comment actions Permalink
  • JeaNae Remala

    I recommend reaching out to Avalara to work with their software product and integrating it into Accounting Seed if you are doing business in multiple sates, jurisdictions, or countries.

    Comment actions Permalink

Please sign in to leave a comment.