Give the time Manager has had this accounting error I would be surprised if in was fixed in the near term. For those who are concerned about compliance with record keeping requirements when submitting financial records to the taxation department, the following is a summary of how to work around Managers current limitations.
The easiest way to do this with cash transaction is use “Receipt” as a flag to indicate the transaction is a sale, and use “Payment” as flag to indicate the the cash transaction is purchase. In practice this will already the case for most cash sales and purchases.
The steps are:
-
Find cash sales not entered as receipts and cash purchases not entered as payments (via a custom report or drilling down on expense/income accounts and sorting by transaction type)
-
Find negative line items in cash purchases and Negative line items in cash sales (via a custom report).
-
Calculate a corrected “Tax Summary” report and use that to calculated GST reporting data
In more detail.
Cash purchases not entered as payments can be found manually by drilling down from the summary screen on each expense account, clicking on the “Transaction” heading to sort by it then click again to reverse the sort order (and look at the other end of the list).
Similarly for cash sales, drill down on each income account, click on “Transaction” heading twice and confirm all are “Receipts”.
This process can be automated by marking all expense accounts, such as by appending a period character “.” to the end of each account name then using this custom report to find all negative amount expenses ie Expense refund which should be negative Payments.
Similarly all income accounts can be marked by appending a character such as semi colon “;” to the account name. The following custom report can then be used to find all negative amount sales ie Sales refunds which should all be negative Receipts
After this has been done all transaction have a flag indicating to Manger if the user has the documentation required to by the tax department to be retained for a Sale or the documentation required to by the tax department to be retained for a purchase. These flags can then be used to find any line items Manager does not report consistent with the users obligations.
Negative line items in cash purchases are displayed by this custom report. Manager incorrectly assumes they are positive value sales so all must be subtracted from sales (to correct Managers error) then subtracted from purchases (to implement what the user entered)
Similarly negative line items in cash sales are displayed by this custom report. Manager incorrectly assumes they are positive value purchased so all must be subtracted from purchases (to correct Managers error) then subtracted from sales (to implement what the user entered)
Finally the Tax Summary" report can be updated, from which the GST reporting totals can be calculated. This is most easily done in a spreadsheet as Mangers “GST Calculation Worksheet” localisation can not be used.