Tax Invoices appear under Purchases on a Tax Detail – Cash Net Report

Legacy KB ID: 4986

Question

Why are tax invoices appearing under Inputs (Purchases( on a Tax Detail – Cash Net Report?  I though the purpose of this report was to separate outputs (Sales) from inputs (Purchases).

Answer

You may experience this issue if you sort the report by Tax Code.

This behaviour is not consistent and another time you sort this report it may sort properly.

Workaround

1.    Refresh the report by:

a.    Sort by a different category and then sort by Tax Code again

b.    Change the date range and change it back.

2.    Create another report to produce the same information.  You will need to create 2 reports, one for Purchases and one for Sales.

a.    Open a Custom Transaction Detail Report

b.    Add and Remove columns to show Cash Net columns

                               i.    Modify Report > Columns > tick and untick column options

                              ii.    Required columns:

1.    Type

2.    Date

3.    Name

4.    Num

5.    Description

6.    Tax code

7.    Other Columns:

a.    Purchases:  Amount and Open Balance

b.    Sales:  Original Amount and Paid Amount

c.    Optional (Purchases):  Paid

c.    Set Filters:

Modify Report > Filters >

                               i.    Purchases:

1.    Transaction Type > Multiple Transaction Types:

                                                            i.    Cheque

                                                           ii.    Journal

                                                          iii.    Bill

                                                         iv.    Bill Credit

                                                          v.    CCard Credit

2.    Tax code > Multiple Tax Codes:

a.    All Capital Acquisition tax codes:  CAG, CAF, CAI and other capital purchase custom codes

b.    All Non-Capital Acquisition tax codes:  NCG, NCF, NCI, GST-P, and other non-capital purchase custom codes

                              ii.    Sales:

1.    Account > All income/expense accounts

2.    Name > All customers/jobs

3.    Transaction Type > Multiple Transaction Types:

                                                         i.    Tax Invoice

                                                        ii.    Sales Receipt

                                                       iii.    Adjustment Note

                                                      iv.    Journal

                                                       v.    CCard Refund

4.    Tax code > Multiple Tax Codes:

a.    All Sales tax codes:  GST, FRE, EXP, INP, NCG-S, and other sales custom codes

d.    Set Date Range to Last Financial Quarter or Month.

e.    In Sort By, select Tax Code

f.     Add an appropriate title for the Report:

                                          i.    Cash Net – Purchases by Tax Code

                                         ii.    Cash Net – Sales by Tax Code

g.    Memorise the Report.

3.    Export the Reports to Excel and combine them there. 

Need more help?

Ask the Reckon Community at: https://community.reckon.com/

Or Log a Support Ticket: https://www.reckon.com/au/support/