Discrepancies on reports

Nadine
Nadine Member Posts: 52
edited July 2020 in Reckon Accounts (Desktop)
Should the net income figure on the p&l be different to the net sales figure on the tax liability reports? I am a bookkeeper so I fully understand these reports and would say "no" to this question myself but I am new to Reckon so possibly I am interpreting the reports wrong. But in summary, if I add up all the net sales figures reported on our BAS from the tax liability summary reports these do not equal our net income figure on the P&L for the year, and we charge GST on all of our sales.

Comments

  • John Graetz
    John Graetz Member Posts: 1,651 ✭✭✭
    edited July 2020
    Hi Nadine.  Another possibility.  Are both sets of reports being run in the same format e.g. both are run on a cash basis or both are run on an accrual basis?  John L G
  • Nadine
    Nadine Member Posts: 52
    edited July 2017
    Ok, I didnt realise this was an option with P&L reports (to run as gross figures), as it isnt with other software programs I am used to. I will give this a try and see if it makes any difference. Thank you for your advice.
  • Nadine
    Nadine Member Posts: 52
    edited November 2016
    Hi John
    Yes I have checked that they are both set as accrual reports. Thanks for your response.
  • Nadine
    Nadine Member Posts: 52
    edited July 2017
    Ok, good to know. Thanks
  • DebonAir
    DebonAir Member Posts: 392
    edited May 2017
    If you find that these figures have not balanced, you might like to run a tax detail report and check that all of the tax codes have been correctly used in sales and expenses. 
  • Nadine
    Nadine Member Posts: 52
    edited July 2017
    Hi DebonAir
    Thank you for your response. I have just done this, and I notice that any general journal entries where the tax code has been left out have ended up under "net sales" without a GST entry for some reason, so this is definitely clouding the accuracy of the reports. 
    I am more familiar with MYOB than Reckon. In MYOB if you do an internal journal entry etc, you code it to NT (non-reportable). What is the best option for tax coding such entries, in Reckon?
  • DebonAir
    DebonAir Member Posts: 392
    edited May 2017
    Hi, the journals can be found in the Tax Exemption Report. You can add in a new tax code as NT if that would make your life easier. I have noticed that people do that in Reckon when they come from MYOB but I never use this myself.

  • Nadine
    Nadine Member Posts: 52
    edited July 2017
    The journals are actually showing up as part of our 'net sales' figures on the tax details report.
  • DebonAir
    DebonAir Member Posts: 392
    edited May 2017
    The tax reports select items based on the tax codes and sort accordingly, which is why you might have an invoice in the expenses section of the report if you have used NCG instead of GST and vice versa.
    You might need to run a P& L by detail, then add in the Tax Code so you can scan each line to ensure you have the correct tax codes on sales and expenses. 
    If your detailed report is very long, then a quicker way to scan is to filter the P&L report by one tax code at a time. This will allow you to quickly find an incorrectly placed tax code. Eg, GST code should not show up in expenses. If you find an incorrectly coded item you can open it and change it quickly. Or, if that has no results, then filter the P&L by No Tax Codes and find items that do not have codes allocated. 

  • DebonAir
    DebonAir Member Posts: 392
    edited May 2017
    These 2 reports should always balance if you have used tax codes correctly. 
    Did you add the 2 Sales lines together from the tax liability report? You have a line for GST sales and further down there are the GST Free sales. 
  • Nadine
    Nadine Member Posts: 52
    edited July 2017
    Our GST Free Sales has a negative balance and this is due to coding errors which I have now been able to find from running this report you mentioned above. There are a lot of transactions to go through but I can see the benefit of doing it. Thanks so much for your advice.
  • DebonAir
    DebonAir Member Posts: 392
    edited May 2017
    As you correct these tax coding errors, you might take a note to check the items or the income account on Chart of Accounts has been set up correctly. If the wrong tax code is in these areas then this will be an ongoing problem if not corrected.

  • Nadine
    Nadine Member Posts: 52
    edited July 2017
    Hi DebonAir
    Thanks heaps for your help today. I think I am now on track to sorting out this issue and yes I have most definately fixed the coding errors to ensure this doesnt happen further down the track. I am not new to bookkeeping but new to Reckon and I am still getting my head around the best reports to run for "what" purpose. The one you suggested was just perfect to find the issues. Thanks again.
  • DebonAir
    DebonAir Member Posts: 392
    edited May 2017
    Thanks Nadine.  I have always run these two reports to find the errors as it will filter out anything that is not right. Usually the problem  is a missing tax code or an incorrectly placed tax code. This will become second nature to you as time goes by.