The Book-keepers Forum (BKF)

Post Info TOPIC: Sage Instant Accounts


Member

Status: Offline
Posts: 9
Date:
Sage Instant Accounts
Permalink Closed


I've been asked to help a small local company with computerising their accounts.  Company has been trading for 18 months approx and directors have purchased and installed Sage Instant Accounts. 

No paper records have been kept to date so I was going to set up sage from stratch but one of the guys in the office beat me to it and feels he's done me a favour by entering all the purchase invoices.  Trouble is he's treated everything like it has been bought on credit using the batch invoice function.  Also, I'm not sure he has changed the program date to within the previous financial year.

Am I better starting from stratch or trying to journal the corrections?  Also, will the program date make enough of a difference? 

 



__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Okay, you may or may not have a couple of problems - but one of the problems you think you might have might not actually be a problem after all. Clear? No? Good... then I'll begin. :)

The fact that he has posted all the purchase invoices via the purchase ledger is not actually a problem. Even if an item wasn't bought on credit, and was paid 'over the counter' or whatever, the fact that it was posted to the purchase ledger just means it has to be cleared via a supplier payment rather than entered as simple payment instead.

Also, even if he didn't change the program date, there's no problem - as long as he correctly dated the transactions he has input.

That's where your first real (potential) problems lies: Has he entered those transactions correctly - with the right date, to the right nominal codes and accounting for the VAT as appropriate?

Your second real problem is with the set up itself: Has he set the right financial year within Sage?

If he's dealt with the postings themselves correctly, you can re-use his work instead of doing it all over again - even if the financial year is incorrect. And even if he's messed the postings up, it might still be preferable to use what he's done rather than start again; it depends how much of a mess he's made.

So your starting point is to look at those two issues: The financial year, and whether the postings have been entered correctly.


__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Member

Status: Offline
Posts: 9
Date:
Permalink Closed

Thank you for your reply - I think I understand lol. I know I can "pay" the purchase invoices - my concern was even all the expenses had been entered this way and if he used the correct nominal codes surely they will be on the wrong side and this will skew the purchases figure in my trial balance.

__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

If you mean expenses as in those incurred by employees or directors, which are to be reimbursed, then they should still be on the right side. Being posted to the purchase ledger means they are creditors, and will remain so until the expense is repaid via a payment to the purchase ledger.

In general, creating a purchase ledger account for the expenses of each individual who might incur them is a sensible move - although given what you've already said, the question is whether or not the person who posted them actually did that, or instead created purchase ledger accounts for the places the expense items were purchased. Or for that matter, if they posted them to a silly nominal code - perhaps an 'expenses control account' or something like that, so they'll be creditors on the purchase ledger, and debtors on the control code. (The debits should, obviously, have gone to the relevent P&L codes - but if that's the case, all you'll need to do is analyse what's in that code and journal it out to the right places).

The worst case scenario is that the postings themselves are wrong - in which case whether they are salvagable depends just how wrong, so I'd say start with this expenses situation, and the general nature of the postings: Have a look to see if all that is correct first - the dates, VAT and nominal codes, etc.

If that is - largely- correct, it's easier to re-use the existing postings.

Then look at the financial year. If the year is wrong, but the above is correct, I'll try to guide you through exporting the data, and then re-importing it after you've set Sage up correctly.

(Re-importing it is the easy part - but exporting it is a bit fiddly because it needs a report to be modified, and then - possibly - the exported data to be modified in a spreadsheet.)

If both are okay, you've no significant problems.


__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Member

Status: Offline
Posts: 9
Date:
Permalink Closed

"or instead created purchase ledger accounts for the places the expense items were purchased"

I think he did this - he commented that it took him ages to enter everything because he had to create supplier accounts for everyone, even the garages he bought fuel from and named Sainsburys and Tesco.

I'm going to see him this afternoon so I'll have a much better idea what I'm working with after I've had some time to look properly at his figures. Thanks for all your help.

__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Ouch. That could potentially be a lot of work clearing them down from the individual accounts, or a lot of work correcting them. Ideally, they need to be corrected rather than cleared down from where they are. There's no quick fix for that - especially if it's a lot, which it sounds like there is. :(


__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Member

Status: Offline
Posts: 9
Date:
Permalink Closed

That's what I suspected. I was weighing up in my mind the time it would take me to re-enter them (nothing else has been entered bank or sales -wise) versus the time it would take for me to correct the entries. I will be able to tell from the Trial Balance.

__________________


Member

Status: Offline
Posts: 9
Date:
Permalink Closed

It wasn't nearly as bad as I thought it was.

The financial year was correct and the entries/postings were mostly correct for the one month I had time to fully check. A couple of wrong nominal codes, one invoice entered twice, one with T1 instead of T0 and the rest were odd 1p's due to VAT calcs (journal entries for 1p?) An hour's worth of journal entries and we'll be ready for the next step.

Taking one month at a time we're going to enter the sales invoices next then try to reconcile with the bank.

I'm going to take your suggestion of setting up control accounts for each director (In the early months they paid for expenses personally then took the money in a lump sum from company bank account.) That way I can clearly reconcile the payments from the bank to a group of expense receipts. I'm glad I didn't re-enter them as bank payments because I wouldn't have been able to reconcile so easily.

Found out today that the company also uses a factoring company - Debtors will be what the factoring company owes us. If I've got this right in my head I'll 1) set up new account for factoring, CR Debtor Control/individual supplier accounts, DR Factor Control then 2) when the factoring company pay us CR Factor Control, DR Bank. Should I set-up Factor Control as a "Bank Account"?

I'll have a look-see if there is a factoring thread here somewhere.



__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Glad things aren't as bad as you feared. :)

For advice on dealing with factoring in Sage, look no further. :)



__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Member

Status: Offline
Posts: 9
Date:
Permalink Closed

did you mean to send me back to this thread with your link?

Have seen the Factoring threads here - very useful and glad to see I was right in that it would be a bank account/loan account.

__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Oops, yes. I was so tired I was practically sleep-posting yesterday. I actually meant to link to this thread: How to account for factoring - but it looks like you found it anyway.



__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About