Tax Summary Report (how to list the detailed transactions)

Alex_6970822
Alex_6970822 Member Posts: 13
edited January 2020 in Reckon Accounts (Desktop)

Is there a report to list the detailed transactions for the Tax Summary Report?

I need to explain some GST issues and these detailed transactions (including the Tax Code) should resolve.

The listing should also include the transaction amount as well as the GST amount.

The Tax Detail Report does not appear to show GST Free Sales (tax code FRE)

Comments

  • Charley
    Charley Member Posts: 541 ✭✭✭
    edited January 2020
    Pick up a detailed report by Tax Code; Lists>Tax Code and then filter which ones you need
  • Alex_6970822
    Alex_6970822 Member Posts: 13
    edited November 2014

    Hi Charles

    Thanks for your help, but I've tried this as per detail in my question.

    The Tax Detail Report does not include GST Free Sales (Code "Net FRE") on the Summary Report.

    Also I need to know the actual trans amount because the tax amount would be zero for GST free sales (to reconcile back to the total of GST free sales amount on the summary report. 

  • Charley
    Charley Member Posts: 541 ✭✭✭
    edited January 2020

    OK different one; Custom Transaction Detail Report for the period you want and then display the Tax Code and Tax Amount, you might also have to filter the Detail level to get what you want.

    You can also do this with a Profit and Loss Detail but where there is a split transaction in expenses it might show the full tax amount on both lines

  • Charley
    Charley Member Posts: 541 ✭✭✭
    edited January 2020
    You can show the FRE on the Tax Summary report by modify report and on the first tab go advanced and all columns
  • Alex_6970822
    Alex_6970822 Member Posts: 13
    edited November 2014

    Thanks Charles - this Custom Trans Detail Report might do the trick.

    I had previously tried the standard Trans Report & modified to include the Tax Code - but it still did not show.

    I see however that the "GST" code is used for both Sales & Purchases (in my case anyway) - so I wonder how the Tax Summary Report knows how to split between "Net GST": GST for Sales & Net "GST-P": GST for Purchases (probably by account type?).

    P&L would not do because there can be non P&L type transactions that may have a tax code (eg capex).

  • Alex_6970822
    Alex_6970822 Member Posts: 13
    edited November 2014

    RE FRE on the Tax Summary Report - I already have this shown - as mentioned what I really need to see are the detailed transactions making up the FRE code & all other codes on the Tax Summary Report.

    Keep up the good work Charles - Cheers.

  • Charley
    Charley Member Posts: 541 ✭✭✭
    edited January 2020

    I use NCG or NCF for purchases and CAG or CAF for Capital Acquisition and that way they separate out, much easier to follow.

    If only using GST then income will be plus GST and purchase will be minus GST.

    Strongly recommend using Tax Codes as designed and then using Tax Summary Report in Gross (rather then Net) then that should match your BAS

  • Alex_6970822
    Alex_6970822 Member Posts: 13
    edited November 2014

    Agree with better to keep separate codes - but have to deal with client's situation (it is what it is)!

    Only using GST code for any sales, purchases and adjustments and bad debts.

    So sales adj is minus GST, purchases adj is plus GST and bad debt should be minus GST.

    How do u reckon the Tax Summary Report manages these?