Reckon one BAS figures don't match income

Tash SchippTash Schipp Member Posts: 23
edited August 2019 in Reckon One
Bit of back story- start of April I swapped from an excel spreadsheet to Reckon One and input all my invoices and got told not to worry about dates so I just entered them all on the date in April. Got all my books up to date to do the first 3 quarters and the incomes on the bas reports are all $0 or wrong. I thought it would of done them from the dates I marked invoices paid. The only thing I can think is all the invoices were put in on April dates then matched up to deposits- so maybe that's where it goes wrong? Will I need to mark all as unpaid and re-enter all invoices on dates I sent them out or ??? I don't know what to do. We work on a cash basis so invoices usually only count on the day they are paid.

Comments

  • ZappyZappy Accredited Partner Posts: 4,661 ✭✭✭
    edited August 2019
    If the invoices were already paid you didnt need to enter them at all. You could just record the cash received as income. It would also be recorded on the correct date since it would come directly from the bank statement
  • Tash SchippTash Schipp Member Posts: 23
    edited May 2017
    Wish I would of known that then. Would saved me a tonne of work. Was just doing what the book keeper said. But what can I do to rectify it now is my issue.
  • ZappyZappy Accredited Partner Posts: 4,661 ✭✭✭
    edited August 2019
    Tash have you reconciled the bank? Thats the first step.
  • Tash SchippTash Schipp Member Posts: 23
    edited May 2017
    Yes I have.
  • Tash SchippTash Schipp Member Posts: 23
    edited May 2017
    Just had a thought- could this be the issues? Everything seems to be coming under 4-0100 instead of 4-000 for income? image
  • ZappyZappy Accredited Partner Posts: 4,661 ✭✭✭
    edited August 2019
    No. Thats not the issue. The bas is produced from the tax codes, not the income accounts. Im happy to have a look at it for you if you like only im in appointments till about 7pm. You can email me [email protected]
  • Lynda ChaterLynda Chater Member Posts: 28
    edited May 2017

    Hi Tash

    I have just been reading your story.  If you do a GST summary mark the date for the financial year, do all your figures appear for the BAS?

    Have you only entered all your figures for the BAS's up until the 31 March 2017 or have you included some April amounts?

    Lynda

  • Alan DoddAlan Dodd Member Posts: 2
    edited May 2017
    Hi,  Have you set up reports to Cash basis?  If not, change the setting as per below and this may fix your problem.  Cheers, Alan
    image
  • Tash SchippTash Schipp Member Posts: 23
    edited May 2017
    I nearly have it up to date- think the last 2 weeks I have to do. Checking the bas summary it's still showing $0 but if i set it to the last couple months it shows pretty much all the money. I gather it hasn't assigned it to the dates it was deposited but the invoice dates. Like some were paid in July but when I input all those invoice in I was told not to worry about dates and they were set to say 21st of April when I input the invoices.
  • Tash SchippTash Schipp Member Posts: 23
    edited May 2017
    Yes. Set on cash basis. First thing I checked.
  • Lynda ChaterLynda Chater Member Posts: 28
    edited May 2017

    Hi Tash

    Because you have put all your dates in April, the amounts are not going to show up in any of the previous quarters GST reports or BAS's. They will only show in the April May period.

    If you have any bookkeeping/accounting experience you can divide the figures up to lodge your BAS's, that way it will save you having to re enter the figures. Or just take the reports to your accountant and he/she should be able to help you.

    Thanks

    Lynda

Sign In or Register to comment.