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

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

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

Hi Terresa

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

Reports > Tax > Tax Detail Report

Terresa

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

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.

Reckon Accounts Hosted Announcements & Important Info

Check out the latest important info & announcements for Reckon Accounts Hosted

Button

View all Reckon software categories 🗃️

Each Reckon software has its own dedicated category on the Community. Click below to browse all categories.

Explore all categories