ATAR Notes: Forum

VCE Stuff => VCE Business Studies => VCE Subjects + Help => VCE Accounting => Topic started by: Damoz.G on November 08, 2013, 04:43:52 pm

Title: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 08, 2013, 04:43:52 pm
Hello Everyone,

As we are all studying for the Accounting Exam on Monday, I thought I'd share with you something that helped me. I made some blank Ledger Templates for the main 4 Accounts that commonly need to be reconstructed (Debtors Control, Stock Control, Creditors Control and GST Clearing).

All you have to do is print out some copies of them (However many you need to commit all Entries to memory), and then just fill it in without using your Notes or the answers and also time yourself to see how quickly you can do them. If you commit them to memory and can do them quickly, it will be very easy for you on Monday during the Exam to just simply fill in the figures, and you're done. No need to think about where everything goes. :P

IMPORTANT - PLEASE NOTE: You don't need to write the stuff in brackets. In the Answers, the bits in the brackets are just to tell you where the figure comes from or what its for, so don't write the brackets out as well. There are more entries for some of them, but these are the main ones. Also take note of the Arrows and "OR" - This is because you can only only have one or the other, but not both. e.g. You can't have a Stock Gain and Stock Loss - Its one of the two only, not both. 

If you have any Questions about it, feel free to ask. Happy to answer any Past Exam Questions as well.

Good Luck!

Damoz.
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: shooterblitz on November 08, 2013, 04:51:58 pm
You Sir, are a legend!

EDIT: Would you have the same templates for Depreciation of NCA's, Accumulate Depreciation of NCA's (the same I told you on the other thread I needed to focus on for the exam :P)
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 08, 2013, 04:55:55 pm
You Sir, are a legend!

EDIT: Would you have the same templates for Depreciation of NCA's, Accumulate Depreciation of NCA's (the same I told you on the other thread I needed to focus on for the exam :P)

HAHA! Thanks mate. :D

Ermmm....no I don't, sorry. There aren't a lot of Transactions that go into those Ledger Accounts so I didn't make Templates for those Accounts. =/ Is there something specific about them that you need help with?   ;)
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: jhon9728 on November 08, 2013, 05:35:22 pm
I was going to open a thread for this but I'll just ask you here.
How do I know whether to put GST Clearing with the Sales in the Debtors Control reconstruction.
I always add it as 10% of the Sales, yet as I am doing practice exams it seems that some include this value and others leave it just at Sales.

So do they accept both? is there some part of the questions which will tell me to include or not?
thanks
(VCAA exam 2, 2008 is an example of this in the account reconstruction, does not include GST)
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 08, 2013, 05:39:37 pm
I was going to open a thread for this but I'll just ask you here.
How do I know whether to put GST Clearing with the Sales in the Debtors Control reconstruction.
I always add it as 10% of the Sales, yet as I am doing practice exams it seems that some include this value and others leave it just at Sales.

So do they accept both? is there some part of the questions which will tell me to include or not?
thanks
(VCAA exam 2, 2008 is an example of this in the account reconstruction, does not include GST)

VCAA only introduced GST for Budgeting and Account Reconstructions as of 2011 onwards. Prior to 2010 inclusive, GST was not recorded for Budgets and Account Reconstructions. So for 2008 and stuff, don't worry about the GST. :)

So you are correct to add 10% GST (and you have to on our Exam on Monday if a question came up), but don't worry about it for older papers before 2011.

Hope this helps!
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: jhon9728 on November 08, 2013, 05:49:02 pm
Thanks, that basically clarifies the whole thing. Now I just need to work on accrued revenue/expenses, they always cause trouble with me as I try work out what has been earned for what months, and not others.
I don't know if you can help with specific examples, but with ones such as :

On 11 October 2007 the business paid $3 960 (including $360 GST) to renew the annual insurance policy due to expire on 31 October 2007 (Chq. 1245). The payment was correctly recorded in the Prepaid Insurance account. On 30 June 2008, before any adjusting entries, the balance in the Prepaid Insurance account was $4 720.
Prepare the necessary General Journal entries to record the balance day adjustment. (relating to insurance for the year ending 30 June 2008)

The interest/accrued expense was recorded at $3520 in the answers, but I cannot see how this was obtained, and the average for this exam was 1.4/4, so i guess I am not the only one.
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: lmaoss on November 08, 2013, 05:58:16 pm
Thanks, that basically clarifies the whole thing. Now I just need to work on accrued revenue/expenses, they always cause trouble with me as I try work out what has been earned for what months, and not others.
I don't know if you can help with specific examples, but with ones such as :

On 11 October 2007 the business paid $3 960 (including $360 GST) to renew the annual insurance policy due to expire on 31 October 2007 (Chq. 1245). The payment was correctly recorded in the Prepaid Insurance account. On 30 June 2008, before any adjusting entries, the balance in the Prepaid Insurance account was $4 720.
Prepare the necessary General Journal entries to record the balance day adjustment. (relating to insurance for the year ending 30 June 2008)

The interest/accrued expense was recorded at $3520 in the answers, but I cannot see how this was obtained, and the average for this exam was 1.4/4, so i guess I am not the only one.
So at June 30 2007, there was a remainder balance of 4720 - 3600  = 1120
On October 30 2007, there was a payment of 3600 so it increased to 4720
So the total expense would be the amount between June 2007 to October 2007 (1120) and the new amount between October 2007 to June 2008 which is calculated as so:
3600 is an annual payment. So divide that by 12 which is 300 expensed per month. Between October and June there are 8 months so that amount would be 2400.
So the total amount is 2400 + 1120 = 3520

Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 08, 2013, 06:09:42 pm
Thanks, that basically clarifies the whole thing. Now I just need to work on accrued revenue/expenses, they always cause trouble with me as I try work out what has been earned for what months, and not others.
I don't know if you can help with specific examples, but with ones such as :

On 11 October 2007 the business paid $3 960 (including $360 GST) to renew the annual insurance policy due to expire on 31 October 2007 (Chq. 1245). The payment was correctly recorded in the Prepaid Insurance account. On 30 June 2008, before any adjusting entries, the balance in the Prepaid Insurance account was $4 720.
Prepare the necessary General Journal entries to record the balance day adjustment. (relating to insurance for the year ending 30 June 2008)

The interest/accrued expense was recorded at $3520 in the answers, but I cannot see how this was obtained, and the average for this exam was 1.4/4, so i guess I am not the only one.

Okay from July 1 to October 31, the balance would have been $1,120. So this whole Expense has been consumed.
Then November 1 to June 30: 8 months consumed. (3600/12) x 9 months is $2,400

$1,120+$2,400=$3,520

It helps to draw up a timeline. :)

EDIT: Beaten
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: huss48 on November 08, 2013, 06:26:03 pm
Good stuff there Damoz, I have also attached a template for financial reports - cash flow, income statement and balance sheet and ratios to remember.
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 08, 2013, 06:31:24 pm
Good stuff there Damoz, I have also attached a template for financial reports - cash flow, income statement and balance sheet and ratios to remember.

Thanks, huss. :)

Those two documents are very useful to remember where everything goes and the formatting of each report as well. Awesome job! ;)
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: TimmyC on November 08, 2013, 06:34:27 pm
Many thanks!

Very much appreciate the work you put in on this forum, it doesn't go unnoticed!!   :D
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: bibsa on November 10, 2013, 12:02:19 pm
After thinking I knew nothing on reconstruction, I think I did well only forgot a couple in the GST.
Does it Matter on the order of the entries. Your answers are pretty similar to the Cambridge Book and I'm wondering if i will be penalized on this??

Thank you  :D
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 12:08:51 pm
After thinking I knew nothing on reconstruction, I think I did well only forgot a couple in the GST.
Does it Matter on the order of the entries. Your answers are pretty similar to the Cambridge Book and I'm wondering if i will be penalized on this??

Thank you  :D

On tomorrow's exam, if and when a Reconstruction does come up, it doesn't matter what order you put the items in just as long as everything is in there and the figure required to be found is clearly stated.

However, for the GST Clearing account to be safe, you should put the GST Settlement/GST Refund first to show that it occurs at the start of the Reporting Period. But I've been told that you shouldn't get penalised if you don't do this either - The main thing is to just make sure all Entries are in the Ledger and that the required figure is correct. :)
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: abcdqdxD on November 10, 2013, 12:19:04 pm
However, for the GST Clearing account to be safe, you should put the GST Settlement/GST Refund first to show that it occurs at the start of the Reporting Period. But I've been told that you shouldn't get penalised if you don't do this either - The main thing is to just make sure all Entries are in the Ledger and that the required figure is correct. :)

I'm pretty sure you must do this or you may risk losing marks depending on the assessor
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 12:23:19 pm
I'm pretty sure you must do this or you may risk losing marks depending on the assessor

Really? I've been told that the order doesn't matter for Reconstructions and that it only matters for the posting of Journals to the General Ledger Accounts.

As I said before, to be on the safe side, put in the GST Settlement or GST Refund to avoid losing the mark for it. But the order of the rest of the Entries doesn't matter, do they? As long as the Opening and Closing Balances are in the correct positions and the accounts are totalled.
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Kuroyuki on November 10, 2013, 12:45:18 pm
If the order did matter, its like saying we will be penalised depending on which journal we post first cash payments or purchases.
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: itsalmostover on November 10, 2013, 01:10:05 pm
Thanks Damoz, you've been a real help to me this year :)

Just wondering, for the Stock Control account, would there be a debit 'Capital' if the owner contributed stock to the business?
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 01:13:21 pm
Thanks Damoz, you've been a real help to me this year :)

Just wondering, for the Stock Control account, would there be a debit 'Capital' if the owner contributed stock to the business?

No worries. :D

Yup, it would be a Debit Entry. There's lots of Entries that can go into those General Ledger Accounts, but I just included the main ones that are constantly used.  :)

So in the General Journal:
* DR: Stock Control
* CR:   Capital

Title: Re: Account Reconstructions - My General Ledger Templates
Post by: icecream on November 10, 2013, 07:44:27 pm
You know for the income statement, it's like:
Revenue
Cash Sales
Credit Sales
Less Sales Returns

Do we have to total cash and credit sales before we deduct sales returns? and if we do, which column does the total go into?
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 07:49:27 pm
You know for the income statement, it's like:
Revenue
Cash Sales
Credit Sales
Less Sales Returns

Do we have to total cash and credit sales before we deduct sales returns? and if we do, which column does the total go into?


No. This is how I do it:
REVENUES                              $                      $
Cash Sales                      12,0000
Credit Sales                     12,0000
less Sales Returns             1,000              23,000
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: itsalmostover on November 10, 2013, 07:52:38 pm
No brackets around the Sales Returns figure? :P
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 07:56:45 pm
No brackets around the Sales Returns figure? :P

No, you gotta look closely at the setting out of the Examiner's Reports - That's the format of what I follow.

For the Income Statement, there are no brackets, instead you say "less" or "add".

For the CFS, you use brackets. :)

Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Hayes451 on November 10, 2013, 08:31:54 pm
Great Templates

Was wondering if a 3rd Cost of Sales entry for prepaid sales is required on the credit side of the Stock Control Template?
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 08:39:23 pm
Great Templates

Was wondering if a 3rd Cost of Sales entry for prepaid sales is required on the credit side of the Stock Control Template?

Thank you. :D

For Prepaid Sales? No, you wouldn't need a third Cost of Sales on the Credit Side, because the Prepaid Sales would be converted into Sales (Specifically Credit Sales) and would thus be included as part of the Cost of Sales figure from Credit Sales. :)
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Hayes451 on November 10, 2013, 08:44:53 pm
Thank you. :D

For Prepaid Sales? No, you wouldn't need a third Cost of Sales on the Credit Side, because the Prepaid Sales would be converted into Sales (Specifically Credit Sales) and would thus be included as part of the Cost of Sales figure from Credit Sales. :)

Yeah that makes sense since I've never used it in a reconstruction, for some reason the Cambridge text says otherwise.

Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 08:47:41 pm
Yeah that makes sense since I've never used it in a reconstruction, for some reason the Cambridge text says otherwise.

I use the Cambridge Textbook as well. What page does it state that? ???
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Hayes451 on November 10, 2013, 08:54:53 pm
I use the Cambridge Textbook as well. What page does it state that? ???

Page 408.
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 09:09:54 pm
Page 408.

Oh wow! Completely missed that.

Definitely a mistake, because no Cost of Sales is determined for a Deposit (Prepaid Sales Revenue). When the Deposit converts into a Sale, that is the only time when the Cost of Sales is determined. Can't have a Cost of Sales figure for a deposit. So yeah, its a mistake.  :)

Good find!  ;)
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: icecream on November 10, 2013, 09:26:54 pm

No. This is how I do it:
REVENUES                              $                      $
Cash Sales                      12,0000
Credit Sales                     12,0000
less Sales Returns             1,000              23,000

ohh okay thank youuu :D
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 09:28:24 pm
ohh okay thank youuu :D

No problems!  ;)
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Kuchiki on November 10, 2013, 09:30:52 pm
Definitely a mistake, because no Cost of Sales is determined for a Deposit (Prepaid Sales Revenue). When the Deposit converts into a Sale, that is the only time when the Cost of Sales is determined. Can't have a Cost of Sales figure for a deposit. So yeah, its a mistake.  :)

I'm not sure what your textbook says exactly, but you can have a third Cost of Sales figure in the Stock Control template if you decide to record the Cost of Sales in the General Journal when you make the General Journal entry to decrease Prepaid Sales Revenue and increase Sales Revenue (alternatively, you could record the whole Cost of Sales in the Sales Journal, but you can also record Cost of Sales in the General Journal for the proportion of inventory sold that corresponds to the deposit).
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 09:34:45 pm
I'm not sure what your textbook says exactly, but you can have a third Cost of Sales figure in the Stock Control template if you decide to record the Cost of Sales in the General Journal when you make the General Journal entry to decrease Prepaid Sales Revenue and increase Sales Revenue (alternatively, you could record the whole Cost of Sales in the Sales Journal, but you can also record Cost of Sales in the General Journal for the proportion of inventory sold that corresponds to the deposit).

I understand what you mean, but the VCAA Exams don't do that. They put the whole Cost of Sales figure in the Sales Journal, so its best to stick with that format instead.
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Kuchiki on November 10, 2013, 09:39:07 pm
I understand what you mean, but the VCAA Exams don't do that. They put the whole Cost of Sales figure in the Sales Journal, so its best to stick with that format instead.

Well, in past Assessor's Reports, they've said that they accept both methods.

Just for people who've been doing it this way throughout the year (and to clear up why you can have three Cost of Sales figures on the credit side of the Stock Control ledger), they should know that it's not incorrect. :)
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 09:49:04 pm
Well, in past Assessor's Reports, they've said that they accept both methods.

Just for people who've been doing it this way throughout the year (and to clear up why you can have three Cost of Sales figures on the credit side of the Stock Control ledger), they should know that it's not incorrect. :)

Hmmm...I'm a bit worried about that, because Neville Box didn't say anything about that in last year's Exam 2 Examiner's Report. =/

Do you think with the new Study Design coming in last year, that they changed it where you can only have the Cost of Sales figure in the Sales Journal?
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Kuchiki on November 10, 2013, 10:05:02 pm
Hmmm...I'm a bit worried about that, because Neville Box didn't say anything about that in last year's Exam 2 Examiner's Report. =/

Do you think with the new Study Design coming in last year, that they changed it where you can only have the Cost of Sales figure in the Sales Journal?

That's the way I was taught; it was how I did it on my exam last year and I didn't lose marks on that question, so I don't think they're too fussed. The reports aren't always very detailed (and just personally, after using the Neville Box textbook last year, I don't hold the highest opinion of him).
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Damoz.G on November 10, 2013, 10:09:06 pm
That's the way I was taught; it was how I did it on my exam last year and I didn't lose marks on that question, so I don't think they're too fussed. The reports aren't always very detailed (and just personally, after using the Neville Box textbook last year, I don't hold the highest opinion of him).

Fair enough I guess.

HAHA! Yeah, someone posted yesterday (I think it was abcdqdxD) that there was a mistake in his book, and all of the Accounting students who studied using his textbook all made the same mistake on the Exam and got penalised. Oh dear... =/
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: Kuchiki on November 10, 2013, 10:18:36 pm
HAHA! Yeah, someone posted yesterday (I think it was abcdqdxD) that there was a mistake in his book, and all of the Accounting students who studied using his textbook all made the same mistake on the Exam and got penalised. Oh dear... =/

Haha, glad that didn't happen in my year. But yeah, just general formatting/paragraphing/colour-coding/explanations in the textbook weren't very clear. Our school used Cambridge when I was in Year 11 (so I got to use it for Units 1/2, and it was fantastic), but then they decided to switch to Macmillan in our year. After many complaints, they decided to switch back to Cambridge this year.
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: abcdqdxD on November 10, 2013, 10:24:00 pm
I'm not sure what your textbook says exactly, but you can have a third Cost of Sales figure in the Stock Control template if you decide to record the Cost of Sales in the General Journal when you make the General Journal entry to decrease Prepaid Sales Revenue and increase Sales Revenue (alternatively, you could record the whole Cost of Sales in the Sales Journal, but you can also record Cost of Sales in the General Journal for the proportion of inventory sold that corresponds to the deposit).

Yeah this is how I learnt it as well.
Title: Re: Account Reconstructions - My General Ledger Templates
Post by: EvoFusion on November 02, 2015, 11:16:09 am
Why cant i open the links anymore it says "error 404 not found' :'(