First Previous - Page 1 of 1 - Next Last

Help with Oaklands Tree Care level II computerised

  • Member
  • Practice Licence
  • 40 posts
  • # 102635

ok this is a really stupid question and I was wondering if anyone can help

 

when inputting the customer and supplier details for task one,  you also input their outstanding balance (one creditor, one debtor). 

 

You then have to input the opening balances journal - part of which includes the amounts above. If you put in the journal, then it distorts the creditors and debtors control accounts. If you leave out those two debits and credits as part of the journal, then it does not balance. 

It is obviously something blindingly simple and I am missing it big time!!

any help much appreciated. 

  • 83 posts
  • # 102671

tiddles said:

ok this is a really stupid question and I was wondering if anyone can help

 

when inputting the customer and supplier details for task one,  you also input their outstanding balance (one creditor, one debtor). 

 

You then have to input the opening balances journal - part of which includes the amounts above. If you put in the journal, then it distorts the creditors and debtors control accounts. If you leave out those two debits and credits as part of the journal, then it does not balance. 

It is obviously something blindingly simple and I am missing it big time!!

any help much appreciated. 


 Hi Tiddles,

I did this a while back using Sage Line 50. Sage makes it easy using the Customer & Supplier wizards.

Task 2 (i) Set up your customer accounts by entering the customer information provided into your accounts package (Name, Address, credit limit, opening balance) As you say only Lord Patrick Groves has an outstanding balance of £480 which you enter.

Task 2 (ii) Set up your suppliers accounts too. Only Tool Maintenance Ltd has an outstanding balance of £360 which you add.

Task 3 - Enter the remaining opening balances as at 1st January from the information shown below; you may need to set up or amend some nominal accounts depending on your accounting software

When you enter the remaining opening balances you don't have to enter balances for the Creditors & Debtors. You did this when setting up the Suppliers & Customers accounts. The Debtors (Lord Patrick Groves) and Creditors (Tool Maintenance Ltd) balances should already be there.

I hope that's a help?

Kind regards

Norm


  • Member
  • Practice Licence
  • 40 posts
  • # 102677

Thanks Norm.

 

I did  this, but then when I enter the remaining opening balances in the opening balances journal, if I leave out the debtors and creditors (already input via the opening balances on their records) the journal does not balance! how do you get round that? 

 

many thanks for your input - this is really niggling me and I'm annoyed with myself for not 'getting' it. 

 

tiddles

 

  • 83 posts
  • # 102678

Hi Tiddles,

Sorry. I was making assumptions there!Embarassed

Do you mean the period trial balance doesn't balance?

Norm


tiddles said:

Thanks Norm.

 

I did  this, but then when I enter the remaining opening balances in the opening balances journal, if I leave out the debtors and creditors (already input via the opening balances on their records) the journal does not balance! how do you get round that? 

 

many thanks for your input - this is really niggling me and I'm annoyed with myself for not 'getting' it. 

 

tiddles

 


 

  • Member
  • Practice Licence
  • 40 posts
  • # 102688

Hi there

what happens is that I cannot enter the opening balances  journal - as the debtors and creditors balances make the journal balance. But as I have already put these balances in directly to their records via the opening balances box on their records I cannot put these amounts in again. 

 

If I do put them in, then it doubles the creditors and debtors balances. 

 

sorry if I am being dense!

 

 

 

  • 83 posts
  • # 102699

tiddles said:

Hey Tiddles I think I get you?
You've already input the creditors & debtors opening balances when you added the customers & suppliers accounts.
You enter all the other opening balances then do a Trial Balance report but it doesn't balance because the the creditors & debtors
are showing nil balance when they should show £480 & £360?

Undecided

Hi there

what happens is that I cannot enter the opening balances  journal - as the debtors and creditors balances make the journal balance. But as I have already put these balances in directly to their records via the opening balances box on their records I cannot put these amounts in again. 

 

If I do put them in, then it doubles the creditors and debtors balances. 

 

sorry if I am being dense!

 

 

 


 

First Previous - Page 1 of 1 - Next Last
bottomBanner
loading