Custom Transaction Detail Report Cash Basis issue with 'Amount Paid'

Terresa
Terresa Member Posts: 2
edited June 2019 in Accounts Hosted
I've been using Reckon for 3weeks and I need a GST report to show all transactions for the BAS period, classified by tax codes. I'm following the following steps:
Custom Transaction Detail report
Modified report to correct period / selected Report Basis 'cash' / have ticked: (left margin), Type, Date, Name, Description, Tax Code, and Amount Paid (cash basis) / Total by 'tax code'.
The report is giving 0.00 for all transactions in the Amount Paid column.
Can anyone advise where I'm going wrong?
Thanks in advance.

Comments

  • Adrian_6974554
    Adrian_6974554 Member Posts: 191 ✭✭
    edited February 2017
    Hello Terresa

    Do you mean the total down the bottom is zero or every row shows a zero.
    As the report shows both sides to the transaction the debits and credits, the total of the Paid Amount column comes to zero.

    I would add in the Account column and total by that column. to clearly group the transactions together.
  • Rav
    Rav Administrator, Reckon Staff Posts: 15,305 Community Manager Community Manager
    edited February 2017
    Hi Terresa

    Have you tried generating a tax detail report? Does that give you the info you're needing?

    Reports > Tax > Tax Detail Report


    ℹ️ Stay up to date with important news & announcements for your Reckon software! Click HERE for more info.

  • Terresa
    Terresa Member Posts: 2
    edited November 2016
    Thank you. By ticking 'Tax Amount' in the columns options I was able to get the report I was after. I spoke with the Reckon Help desk this morning who advised that 'Amount Paid' column is linked with Super Liability - which was where I was encountering my issues.
  • Shirley Ingle
    Shirley Ingle Accredited Partner Posts: 138 Accredited Partner Accredited Partner
    edited December 2016

    Terresa  One of the best reports to check your account allocations and at the same time your GST coding is this one.  Reports, Accountant, General Ledger, Click Modify report and tick Tax Code.

    In header/footer name the report General Ledger with tax code. Memorise this report so that you have it whenever you do your BAS or on a monthly basis to check your work.

    Before you do any reporting, go to Edit, Preferences,  Reports and Graphs is set to your reporting basis, either Cash or Accrual. Also when in preferences, tick the box in Reports (top left of the screen). That way when reporting, you nominate the date range before the program runs off and generates the report.