How to adjust an account so you can start reconciling from now on?
Options
ECC
Member Posts: 4 ✭
I currently only reconcile the main business account, I want to start reconciling the tax account and credit card. These accounts have been used in quickbooks for years but never reconciled, how do I start reconciling now starting this f/year? Balance is a long way out.
**Edit - Would it be easier to make these accounts inactive as of 30/6 in quickbooks - and setup a new account for each as of 1/7?
**Edit - Would it be easier to make these accounts inactive as of 30/6 in quickbooks - and setup a new account for each as of 1/7?
0
Comments
-
I would just do a journal as at 30/6 and post the necessary adjustment to retained earnings, calculate the difference between your balance and the bank statement balance0
-
Hi Eastside
Please do not post to retained earnings!!!! If you must use opening balance equity.
How many years are we talking and how were you using these accounts i.e were you just entering the credit card transactions that related to the business only? If yes then this is money you have technically paid yourself and should have been journaled to your loan account, and the credit card acct to bring it back to zero or were you paying the business amount off the credit card with a payment every month, bringing the credit card account back to zero?
With the tax account, if you had set one up to transfer money from the business to tax acoount and monies back this should be simple to reconcile if you have all the statements, did you pay the BAS out of the tax account or bring the money back into the business to pay the tax??0 -
Yes ABS correct, opening balance equity0
-
About 9 years, transactions have been entered into the tax account but the money coming out of the tax account has never been entered. The accountant just sorted that his end.
So, the accountant has asked from now on to start reconciling it on my end - but I'm not sure how to start. I can't go back and enter all the transactions.
Can I just make this account inactive on quickbooks and start fresh with a new account?0 -
For me I would ask the accountant for journal entries at end of last financial year, 30.6.2019. Then make all July entries and reconcile from now on. Is it a tax bank account or the gst payable account you need to reconcile?0
-
Hi ECC
Jnl entries can be done, my concern is what has been paid out of this tax account and if it ever got into your file, especially if the payments out were bas paid, this will mean that your gst collected/paid will be affected, which on cash basis can't be reconciled anyway, but it will also affect the PAYG account, which should be reconciled as well.
I have just cleaned up a MYOB file like this for a client, my biggest concern for you is if the same, there were multiple wrong accounts. There was a 'tfer to BAS' (exp.acct) for when they transferred money from bus. to tax acct. Another one to set up to pay the Bas from the tax account.
If no complications go to reconcile the tax & credit card @30Jun18 (or 19) tick all then jnl the difference to opening bal. equity, reconcile. Reconcile with the statements from 1Jul18 or 19 after this.
if you need help, email me: Kim@kwikbooks.com.au
0 -
Yep you definitely need to investigate the impact of GST as per ABS’ s advice. If those transactions included GST it will be a bigger job.0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community