Goods return (Cash sale/purchase) causes Gross Sales error

Is this how goods return is suppose to be accounted for. For example

  • I buy something say a phone handset for $100
  • Decide it’s no good so take it back to the shop a few days later and get a full refund of $100.

Manager entry to buy handset is

This purchase is reflected in the tax summary (and Localisation “GST Worksheet”) as expected.

I had assumed to return it, an otherwise identical but negative value transaction would be optimal, such as

Looking at the Tax summary in a test business with no other transactions this results in


Which shows a purchase and a sale, which flows through in a similar manner in the localisation worksheet.

Option 2 is to process the return as a positive value receipt such as

However this also produces the same tax summary

I had expected the second option to be handled in Manager as an equal value purchase and sale. I had not expect the first option to also be treated this way.

Am I missing something?
Note using Manger v19.9.28

This looks perfectly normal. A receipt is just the reverse of a payment, so changing the sign converts one to the other. Think about it: they are both entered on the same form:

21%20AM

Changing the Type field just reverses signs.

When I returned the phone handset I made a negative quantity purchase, I didn’t start a phone handset retail business.

Manager keeps track of sales and purchases for each tax code internally.

So to reflect in Manager what was done in reality I needed a way to reduce my purchases for that tax code when the phone handset is returned not increase my sales.

I had assumed the way to reduce my purchases was to enter a negative value purchase, which I believe is how it is done elsewhere in Manager.

Is there a Manager way if entering this transaction I’m missing?

@Patch, I think you are just stumbling over terminology. From an accounting viewpoint, receipts and payments differ only their numerical signs. And the Tax Summary allocates transactions to either sales or purchases based on signs, not whether you actually bought or sold goods or services. You could substitute a dozen other pairs of terms and have the same report (inflows/outflows, debits/credits, additions/subtractions, …).

The determination that matters is what account the transactions were posted too. When you bought the handset, it was posted to an expense account. When you returned it, whether by receipt or negative payment, it was posted to the same expense account, reducing the balance of the expense account. Only if you posted the return to an income account would it show up as increasing your sales. Remember, the Tax Summary report is not the Profit and Loss Statement. It is only a summary of taxable transactions that add to or subtract from the Tax payable account, organized by tax code.

No, and that is the problem.

It is increasing my sales and I want it to decrease my purchases. (I added the pre item return tax summary to the opening post to illustrate). I have posted the tax summary report only because it is available to all Manager users. The report I care more about it the localisation GST/VAT worksheet which has identical changes as it is based on the same tax code Sale/Purchase totals.

So my problem is how do I record a transaction in Manager to reduce my cash purchases after I have made a cash purchase and later return all or part of it?

At the risk of going off topic on my thread and never getting an answer to my current issue (which is actually the issue I want a workable solution for).

Unfortunately I suspect my problem is due to the limited capabilities of Managers current cash sales/purchases functionality. In contrast for business who make all sales and purchases via invoices I believe this functionality is available. The details of how it occurs I believe are, for Purchases:

A similar but reciprocal approach applies to Sales:

In contrast for cash purchases the following approach is taken:

A similar but reciprocal approach applies to cash Sales:

A solution is to treat cash sales / purchases in similar manner to how invoices are processed. So for cash purchases this would mean

A similar but reciprocal approach would apply to cash Sales:

The critical function illustrated are:

  • The transaction relates to a sale or purchase component of the tax code because the user tells Manager it is a sale or purchase not because of the sign of the amount.

  • The changes in Managers behavior only effect transactions with negative “Amount” (which only occur if manually created and really only makes sense for product returns).

  • Item 3 in the above illustrations is there only to show compatibility with Manger later recording cash transactions against specific suppler / customer accounts. This is the subject of a different idea. Implementation probably involves, when a supplier / customer is specified putting the transaction through their account by posting an equal valued credit and debit.

@Patch, you need to explain your statement that a goods return will increase your sales income. Income is not determined by which column transactions are in on the Tax Summary. It is determined by the balance of relevant income accounts. Posting to an expense account and subsequently reversing the transaction does not touch an income account. So how can it increase your income?

When I purchase something for business, typically a 10% GST tax code is applicable. I record this in an expense account. Manager increment the total purchases and total tax on purchases paid against the 10% GST tax code. This information is displayed in the “Tax Summary” report. The same information is given to a localisation of type “Tax Summary”. It is used there to set the tax amounts for each tax code. So after this single transaction that would result in

Localisation variable Amount
netSales[GST_10] 0
taxOnSales[GST_10] 0
totalSales[GST_10] 0
netPurchases[GST_10] 90.91
taxOnPurchases[GST_10] 9.09
totalPurchases[GST_10] 100
taxOnSalesMinusTaxOnPurchases[GST_10] -9.09

If I physically return the item and record it in Manager by posting a negative value cash transaction to an expense account, Manager will assume it is a sale. The payment type setting only changes if I enter a positive or negative amount in the payment / receipt. In both cases it will be add to the total sales recorded against that tax code. This is show both in the “Tax summary” report and the localisation of type “Tax Summary” resulting in

Localisation variable Amount
netSales[GST_10] 90.91
taxOnSales[GST_10] 9.09
totalSales[GST_10] 100
netPurchases[GST_10] 90.91
taxOnPurchases[GST_10] 9.09
totalPurchases[GST_10] 100
taxOnSalesMinusTaxOnPurchases[GST_10] 0

Now if I actually provide a service or sell goods as part of my business for which 10% GST is applicable that will also add to my (real) GST 10% sales.

As a result what is reported in the tax summary (and GST Calculation Worksheet) as income will include my real income as well as the value of any goods I have returned.

This quantity is the first item in the printed GST Calculation Worksheet, labelled G1. It is one of the quantities reported to the tax department each time BAS (Business activity statement) is submitted.

I won’t pretend to have dived into details of localizations for Australia. I will only say you can’t claim your income has increased because a tax report puts a particular transaction into some box. You have to go back to the actual accounting. Maybe the report or localization are wrong, maybe not. But the circumstances are clear. Your sales did not increase. Net profit did, but not sales.

I agree my actual sales did not increase.

Unfortunately with how Manager currently behaves, it will report an increase in my sales. I believe this is independent of country and actual localisation reporting.

The error will currently occur with all cash returns for which a tax code used for both sales and purchases is applicable. To avoid it you would have to ignore the tax code totals and manually externally add up the respective income and expense account totals.

Are other Manager users getting this error? Particularly Manager users who need to report gross sales to their tax authority.

To check

  1. Calculate the Gross sales you will report to your tax authority using what ever method you normally do.

  2. Simulate/enter a business cash purchase applying your normal tax code for a business purchase. To make it easy to see choose a large round number like 10000

  3. Simulate you returning the goods a few days later and getting a full refund into your bank account (by entering your normal returned goods cash transaction into Manager).

  4. Calculate the gross sales you would report to your tax authority using your usual method.

If your method of recording returned cash purchases works, your reportable gross sales Manager suggests should not have changed. If your reportable Gross sales has increased by $10,000 then there is an issue.

Note the only method I can get to work in Manager is it edit the original purchase transaction when returning all or part of a cash (not via invoice) purchase.

To clarify, @Patch, are you referring to what you believe is an error in a report transformation or the P&L statement?

@patch you are confusing P&L sales and expenses with GST sales & purchases - they are not the same thing. The tax summary report, reports GST sales & purchases. That is, transactions where you have received GST and where you have paid GST. Where those transactions appear in the financial statements is unrelated. For example, BS transactions are also listed as GST sales & purchases.

Therefore the Worksheet is correct - it totals all the transactions where you have received GST (the phone refund) and where you have paid GST (the phone purchase). It is a common misunderstanding that GST reporting needs to reconcile with the P&L. If you sell a fixed asset, that is a GST sale but not a P&L sale, or if you buy Inventory, it is a GST purchase but not a P&L expense until it is sold.

At the end of the day, GST reporting is based on the final cash transaction, even though other transactions such as Sales / Purchase Invoices and Credit / Debits Notes get involved in the mix.

For example, you issue a sales invoice for 1000 + 10%. The customer returns half and you issue a credit note for 500 +10%. At this point the sales invoice and the credit note GST get offset under GST sales as no GST has been received. Then when the customer pays their account, the GST received matches the nett of the GST Sales (Invoice - Credit Note)

The credit note is not a GST purchase as there was no GST paid.

I am referring to what a Manager user will report to their tax authority because of purchasing then returning goods. In Australia it is G1, the first number entered in the Business activity statement.

From a software perspective, what reports users use to arrive at this number may vary. I’m mostly interested to know how to use Manager to report accurate figures to the tax department.

From an accounting perspective, the critical issue is, when I return the goods I purchased a few days earlier, was that really a Business sale (so increased my reportable sales) or was I reversing a purchase (so decreases my business purchases).

As an aside both MYOB and Zero will report this to the tax office as a reversal of purchase (no increase in sales). Zero implements it by having separate tax codes for purchases and sales.

I agree Manager calculates sales correctly when invoices are used. That is because the program abides by the users specification of the transactions pertaining to a “Sales invoice” (amounts increasing to decreasing the sales component of the tax code totals) or “Purchase invoice” (amounts increasing to decreasing the purchases component of the tax code totals).

When an invoice is not used (ie “cash sales”) Manager is currently using the sign of the “Amount” to allocate the transaction to sale or purchase component of the tax code. This is different to invoice based transactions when the “Amount” is negative. Which I believe is the fundamental problem.