Debtors/creditors control account in sage
- Thread starter Newbie22
- Start date
or there is a f*** up some where on the postings!
With this and your other postings my suggestion - get a recommended bookkeeper to go through everything asap freeing you up to run the business.
With this and your other postings my suggestion - get a recommended bookkeeper to go through everything asap freeing you up to run the business.
Upvote
0
- Original Poster
- #5
I think the accounts are wrong as I am seeing major irregularities...
i.e. petty cash is a credit balance of £966.89... that cant be right surely?
and the sick thing is my accounts have been audited by a reputable accountancy firm... so I am confused....
so corporation tax is most likely wrong...
Maybe I will have to hire Elaine see if u can sort this mess out for me! But I insist on going out to dinner with my accountant! lol
i.e. petty cash is a credit balance of £966.89... that cant be right surely?
and the sick thing is my accounts have been audited by a reputable accountancy firm... so I am confused....
so corporation tax is most likely wrong...
Maybe I will have to hire Elaine see if u can sort this mess out for me! But I insist on going out to dinner with my accountant! lol
Upvote
0
Get your coat Elaine I think you've pulled!Maybe I will have to hire Elaine see if u can sort this mess out for me! But I insist on going out to dinner with my accountant! lol
Newbie, your company needs to appoint an accountant to deal with the end of year, and you need to liaise closely with them. This needs to happen very soon.
The end of year accountant will still have various things to work through. It can be false economy to try and fix these things yourself - an experienced accountant can likely sort it out quicker than you and it might actually work out cheaper in the long run.
Upvote
0
When they completed your year end accounts they should have provided a schedule of adjustents to make your accounts agree to theirs. From what you say I suspect they have not done this.
Do you reconcile the blances on the indiviual debtor accounts to what they owe you, or the petty cash balance to what is in the tin?
Do you reconcile the blances on the indiviual debtor accounts to what they owe you, or the petty cash balance to what is in the tin?
Upvote
0
- Original Poster
- #8
thats a good idea... I will liase with them tomorrow... I can see that on some of the joural entries there are adjustmet as per joe bloggs which is th accountants... so I tink it is just a bodge job... I mean I am only turning over 3-4 million a year... but its big sales not little sales...
@jenni - elaine shouldnt put her picture up... otherwise I would have just thought she was a boring accountant lol... anyway im too young for her!
@jenni - elaine shouldnt put her picture up... otherwise I would have just thought she was a boring accountant lol... anyway im too young for her!
Upvote
0
With respect, how can you say that? It is evident from your postings and questions that you have, at best, a very tenuous grasp of double entry bookkeeping yet you feel capable of deciding that something presumably done by a professional firm of accountants and a bookkeeper is a bodge job.
Or is " I tink it is just a bodge job" shorthand for "I haven't got a clue?"
Your business is too big for DIY bookkeeping
Upvote
0
I nearly fell off my chair when you said you were turning over 3-4 Mill, spend a few grand per year on a proper bookeeper you tightwad !
Upvote
0
@jenni - elaine shouldnt put her picture up... otherwise I would have just thought she was a boring accountant lol... anyway im too young for her!
too old my a***
Get your hand in your pocket for an accountant with bookkeeping to get this bloody mess sorted out. If turnover is what you say then with the time saved and your silver tongue your will earn back the accountants fee in no time
Upvote
0
I will get an accountant...
Thanks all for your help.... you have all been helpful, even if my question are really daft!
Daft questions are easy to deal with. It's the clever ones wot gets us confused!
Upvote
0
anyway im too young for her!
You seem to know as much about women as you do about accounting. At least you have come to the right place for advice (about accounting anyway).
Where you say your accounts were audited by a respectable firm of CAs, did you actually have you accounts audited or did they just prepare the accounts?
This is an inportant distinction regarding your choice of future accountants as few maintain audit licences these days.
Upvote
0
Newbie, you have fallen victim to the Sage-monster. Try printing out a "Transactional Trial Balance" for the dates of your accounting year, then a "Period Trial Balance" to your year end. Experiment by including or excluding brought forward balances (there's a tick box option). Now take a balance sheet account without too many entries in it - a bank deposit account, or a plant and machinery account, maybe - and compare the differences in the nominal ledger reports (ie all the component figures that make up each balance in those TBs). That way you'll begin to understand the rudiments. Your printouts may vary according to whether or not you went through the year end routine in your accountancy software.
You're not alone in being unable to understand your printouts - most business owners can't either. Come to that many accountants struggle too. Just recently I made a few adjustments to a client's "books" (not Sage, but similar, and HMRC approved software to boot) - just straightforward postings to get payments from the suspense account and into the purchase ledger, and allocate payments to purchase invoices - and then printed out a VAT return. The result was a £1k repayment, which didn't look right to me; so I logged out, logged back in again, ran another VAT return and this time had a £5k repayment, which looked more like it. I haven't figured out whether the rule is that the VAT routine takes no notice of postings in the current session, or whether the glitch occurred because I had pulled up the previous quarter's VAT report prior to running the first (£1k) VAT report for the present quarter. Either way, it ain't supposed to happen, and makes me wonder whether we were all better off with a straightforward set of books: a cash-book, purchase ledger and daybook, and sales ledger and daybook, that didn't try to replicate the entire balance sheet and which business owners (and I) better understood.
You're not alone in being unable to understand your printouts - most business owners can't either. Come to that many accountants struggle too. Just recently I made a few adjustments to a client's "books" (not Sage, but similar, and HMRC approved software to boot) - just straightforward postings to get payments from the suspense account and into the purchase ledger, and allocate payments to purchase invoices - and then printed out a VAT return. The result was a £1k repayment, which didn't look right to me; so I logged out, logged back in again, ran another VAT return and this time had a £5k repayment, which looked more like it. I haven't figured out whether the rule is that the VAT routine takes no notice of postings in the current session, or whether the glitch occurred because I had pulled up the previous quarter's VAT report prior to running the first (£1k) VAT report for the present quarter. Either way, it ain't supposed to happen, and makes me wonder whether we were all better off with a straightforward set of books: a cash-book, purchase ledger and daybook, and sales ledger and daybook, that didn't try to replicate the entire balance sheet and which business owners (and I) better understood.
Last edited:
Upvote
0
Clear as mud, that!
Hang on.... there is a "transactional trial balance" report in Sage?!?! How do you run one of those? Been extracting them manually for years :redface:
Out of interest, what software? (feel free to PM if you'd rather not post it)
Upvote
0
Clear as mud, that!
Hang on.... there is a "transactional trial balance" report in Sage?!?! How do you run one of those? Been extracting them manually for years :redface:
Out of interest, what software? (feel free to PM if you'd rather not post it)
Hmm I'm still scratching my head: VAT return says £1k refund; log out and back in again and run the VAT return a second time and you get a £5k refund. I only spotted it because output VAT was nil and I'd just allocated a few thousand £'s input VAT on the purchase ledger, so £1k couldn't be right. Not with VAT cash accounting. "What the deuce...!", I said to myself.
Ahha Transactional TB in Sage: I've found it makes preparing a set of accounts a little easier because I extract Sage data to an ETB in Excel. Isolates the in-date transactions, rather than adapting the cumulative balances on the Period TB. Click in to the Financial module, then click "Reports", and you have the option of either TB under "Trial Balance Reports". You can produce Nominal Activity Reports to match those TBs (under Nominal Module, then "Reports") by including or excluding the b/fwd transactions.
Umm I'd better not name the culprit software publicly.
Upvote
0
Thanks WG
Yes, transactional TBs doth a far easier job make! Or something... I also ETB to Excel with them.
I will have a peek at the reports next time I'm in front of Sage (thankfully not very often!). I've got the nominal activity one down, but I've been running a normal TB, then mirroring out the o/bals from the NomAct report by manually extracting them. Works, but somewhat longwinded!:redface:
I'm not even going to attempt to work out what was going on with your VAT return!
Yes, transactional TBs doth a far easier job make! Or something... I also ETB to Excel with them.
I will have a peek at the reports next time I'm in front of Sage (thankfully not very often!). I've got the nominal activity one down, but I've been running a normal TB, then mirroring out the o/bals from the NomAct report by manually extracting them. Works, but somewhat longwinded!:redface:
I'm not even going to attempt to work out what was going on with your VAT return!
Upvote
0
You can print off nominal reports with and without the opening balances to make life easier. It once took me yonks to figure out that the current balance figures in the top right hand corner of each nominal account really are the current balances on the day the reports are printed, not at the period end date.
Why doesn't someone produce a spreadsheet that looks like a set of books?
Why doesn't someone produce a spreadsheet that looks like a set of books?
Upvote
0
Upvote
0
Because a set of books looks different to each & every person
Well I liked them when they were big and red
Upvote
0
Like the big red one on J's bookshelf. Next to Great Expectations.
Accountants do it by the book.
Upvote
0
Hey, I've finished all my P35s and it's ummm... well past lunchtime.:redface:
Oh well, voila anyhow!
Oh well, voila anyhow!
Upvote
0
- Original Poster
- #32
Hey WG!
Yeah got on the phone to sage support.. the transactional report was wrong as the chap was saying on the phone running it from 1/1/1980 as to date... as it picks everything up, so balances to me were looking wrong. I take everything back about my accountants, deep down I new they were doing their job properly!
Its a good note for all sage users transaction tb is no good to run for a specific period... you have to run the set reports... I have no idea why sage does this! I am gonna move everything over to sage I think... as the in house system is pants for stock etc... worth the money i think WG.
I actually no quite alot about sage! Not bad for someone born in 1982 yes yes see I told you lot I young!
Cheers for the reply WG! Maybe I take you out to dinner instead! imao!
Yeah got on the phone to sage support.. the transactional report was wrong as the chap was saying on the phone running it from 1/1/1980 as to date... as it picks everything up, so balances to me were looking wrong. I take everything back about my accountants, deep down I new they were doing their job properly!
Its a good note for all sage users transaction tb is no good to run for a specific period... you have to run the set reports... I have no idea why sage does this! I am gonna move everything over to sage I think... as the in house system is pants for stock etc... worth the money i think WG.
I actually no quite alot about sage! Not bad for someone born in 1982
yes yes see I told you lot I young! Cheers for the reply WG!
Maybe I take you out to dinner instead! imao!
Upvote
0
Take a look at Sage's little sister TASbooks: I find it more user-friendly.
I actually no quite alot about sage! Not bad for someone born in 1982
Ling, is that you? :|
Cheers for the reply WG!
Ok, but no beanshoots
Upvote
0
Suitable for a company turning over £3/4m with stock control?
Upvote
0
I see what you mean - TASbooks seems to be the new name for the old TASbooks1. Our hero would need the old TASbooks3, which I guess has now metamorphosized into TAS's new "TotalAccounts" package.
How tiresome of TAS/Sage: TASbooks was / (still is?) the name of the company! But Cheers for pointing it out Zeno. I'm still using TASbooks3 myself - tried and tested, probably still available on Amazon or E-bay, and no doubt cheaper than this year's rebrand.
How tiresome of TAS/Sage: TASbooks was / (still is?) the name of the company! But Cheers for pointing it out Zeno. I'm still using TASbooks3 myself - tried and tested, probably still available on Amazon or E-bay, and no doubt cheaper than this year's rebrand.
Last edited:
Upvote
0
Similar threads
Latest Articles
-
90,000 jobs are heading your way. Your rates bill might get there firstIf you run a business in Manchester, Birmingham, Leeds or Bristol, you were probably told some...- Ozzy
- Updated:
- 8 min read
-
How to Price a New Product or Service: We Asked UKBFOn 5 August, @Data Swami posted in the General Business Forum with a question that ought to have...
- Ozzy
- Updated:
- 7 min read
-
70 years of director bans in six months: Companies House has stopped asking nicelyCompanies House published a release on August 6th 2026 that every company director should read...
- Ozzy
- Updated:
- 7 min read
-
MTD for Income Tax: your first quarterly update is due 7 August.If you are a sole trader or landlord and your gross income from self-employment and property was...- maka
- Updated:
- 4 min read
-
Andy Burnham's Manifesto for Small Business, and How It Stacks Up Against Count BinfaceIf all goes to plan (or rather, to Labour's timetable), Andy Burnham will be sworn in as Prime...
- Ozzy
- Updated:
- 5 min read