Reckon one BAS figures don't match income

  • 1
  • Question
  • Updated 1 year ago
  • Answered
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.
Photo of Tash Schipp

Tash Schipp

  • 324 Points 250 badge 2x thumb
  • frustrated

Posted 1 year ago

  • 1
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 38,584 Points 20k badge 2x thumb
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
Photo of Tash Schipp

Tash Schipp

  • 324 Points 250 badge 2x thumb
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.
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 38,584 Points 20k badge 2x thumb
Tash have you reconciled the bank? Thats the first step.
Photo of Tash Schipp

Tash Schipp

  • 324 Points 250 badge 2x thumb
Yes I have.
Photo of Tash Schipp

Tash Schipp

  • 324 Points 250 badge 2x thumb
Just had a thought- could this be the issues? Everything seems to be coming under 4-0100 instead of 4-000 for income?
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 38,584 Points 20k badge 2x thumb
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 kevin@zappy.com.au
Photo of Lynda Chater

Lynda Chater

  • 370 Points 250 badge 2x thumb

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

Photo of Alan Dodd

Alan Dodd

  • 70 Points
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
Photo of Tash Schipp

Tash Schipp

  • 324 Points 250 badge 2x thumb
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.
Photo of Tash Schipp

Tash Schipp

  • 324 Points 250 badge 2x thumb
Yes. Set on cash basis. First thing I checked.
Photo of Lynda Chater

Lynda Chater

  • 370 Points 250 badge 2x thumb

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