Make journal entries for accrued electricity and gas
- Tila: Closed
- Palkinto: $100
- Vastaanotetut työt: 1
- Voittaja: Shia5
I need someone to create some manual journal entries for electricity A/C (expense A/C), Gas (expense A/C), and accrued electricity and gas A/C (liability A/C).
Period is from 1 may 2018 until and including 31 Aug 2018.
There are 4 different types of invoices received from energy provider (AGL) - 2 bills are received quarterly, and 2 bills are received monthly.
You need to make monthly journal entries for the quarterly and monthly invoices
Please go through the attached excel.
There are 4 sheets in this excel
Sheet-1 - This is where you need to do the journals
Sheet-2 - Few journals made by our accountant (This is a sample for you.) But keep in mind that these journals might not be accurate.
Sheet-3 - Calculations made for the different types of invoices, this will help you to make the journal entries in Sheet-1. You can modify sheet-3 the way you think is correct.
Sheet-4 - Information regarding 4 types of invoices we receive (3 invoices are for gas and 1 invoice is for electricity).
This is a contest, hence I shall be comparing the work of you people.
This work can only be done by someone who has accrual accounting experience. A qualified CA/CPA/ICAA is preferred, but not mandatory. Experience is very important.
Work needs to be 100% accurate.
The person who will win this contest will receive lots of other accounting work from me.
THERE IS ONE ERROR IN THE FILE
CORRECT FIGURE IN sheet-3 J25 IS $4037.32
Remember, everytime an invoice is paid and closed, a payment journal is made by the accounting software and posted.
Hence, your manual journal entries must not include bank.
Only 1 person wins contest. However, even if someone does not win contest but his work is 100% accurate and has good communication skills, there is good chance I shall hire him/her as an hourly accountant for my other assignments. Hence, try to give your best effort.
Message me anytime.
Kilpailun parhaat työt