Splitting books by bank account for Auditors

Hi, our bank accounts changed during the year which included a trust account was added which is now our main account.

Our auditors now want separate set of books for the current account and a separate set of books for the trust account.

All accounting work for the financial year has been completed and year end done.

Is there a easy way of copying a set a books and then deleting transactions not pertaining to that account and reversing opening balances which do not apply to that specific set of books.

Please assist. Greatly appreciated.

Views: 23

Reply to This

Replies to This Discussion

Hi Ian,

Unfortunately there is no easy way to accomplish this, as you cannot delete entries once they're posted.

I can help however as I have have created an Excel-file for myself for management account purposes to extract detail from the TC-database.  This includes individual transactions stored in the db.  From this detail information we should be able to create two sets of trial balances in Excel.

You will then need create two separate sets of books in TC and enter opening balances for each.

Let me know on manahcount%%@%%gmail%%.com  (remove the obvious incorrect chars)

r

You can handle multiple bank accounts in one set of books and pull different reports. Simplest by posting EXCLUSIVELY to different accounts from each batch. One (or two) batches per bank account.

Follow Accounting Made Easy to understand this.

It actually depends on how many bathces he has posted. If there are a few you can unpost, modify and repost to the correct allocations. Works on $ 50 per hour.



Retief Kotze said:

Hi Ian,

Unfortunately there is no easy way to accomplish this, as you cannot delete entries once they're posted.

I can help however as I have have created an Excel-file for myself for management account purposes to extract detail from the TC-database.  This includes individual transactions stored in the db.  From this detail information we should be able to create two sets of trial balances in Excel.

You will then need create two separate sets of books in TC and enter opening balances for each.

Let me know on manahcount%%@%%gmail%%.com  (remove the obvious incorrect chars)

r

Yes, Philip is right: it depends. I haven't used reverse batch posting much, so did'nt consider that as an option. That can work. Then you can create a copy and start the different sets or the normal and 'trust' bank account from there.

Having two sets reduces the chance of posting to incorrect accounts. The 'trust'-account should not form part of your balance-sheet report in any possibility if you want to create true "separation of assets".

At first I too was scared of reversing batches. Once you know that it actually works it opens a whole new world.  Very adictive - dangerous. Use backups. See access control for the audit trail.

Reply to Discussion

RSS

Blog Posts

Open source software and economic inequality

Posted by Philip Copeman on May 4, 2017 at 14:00 0 Comments

Open source software offers Governments the opportunities to build the knowledge economy and built it inclusively.

The World Economic Forum roadshow is back in town again. Economic experts on sponsored trips with generous expense accounts check into the beach front hotels amid fan fair and flashing cameras. They are offering us more advice than President Trump gets. Exotic terms like “inclusi…

Continue

There Are As Various Kinds Of Grass As Flowers

Posted by Kirsten Sue on December 19, 2016 at 17:50 0 Comments

CSA is Community Supported Agriculture, that is far more fresh produce. It is actually opportunity to participate a great environment that provides sustainably grown manufacture and to ascertain additional concerning the community and ecology that provides these merchandise for u . s citizens.

Your first phase to having an excellent six packs diet is counting your calorie absorption. You can download an excellent calorie counter on the online world. Once you do this…

Continue

TurboCASH Subscription December

Posted by Philip Copeman on December 7, 2016 at 0:04 0 Comments

If you would like to get the maximum out of TurboCASH Accounting and your Windows 10 PC, sign on for the TurboCASH 5 subscription at $60 per year. The new version makes it a whole lot easier to run a paperless office using PDF filing, Accounting Made Easy is included. Spend a few hours on improving your understanding of finance this month and start the new year with a boost.

Buy N…

Continue

How Trump beat his taxes.

Posted by Philip Copeman on November 15, 2016 at 11:30 4 Comments

 Unless you have been under a rock for the last 6 months, you must have followed how President Elect Donald Trump avoided income tax over the last few years. He did this by using Depreciation!

Its all legal of course and most Governments offer you this…

Continue

Events

Videos

  • Add Videos
  • View All

© 2017   Created by Philip Copeman.   Powered by

Badges  |  Report an Issue  |  Terms of Service