Make journal entries for accrued electricity and gas

  • Statusi: Closed
  • Çmimi: $100
  • Kandidaturat e marra: 1
  • Fituesi: Shia5

Përmbledhja e konkursit

Hello,

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.

Thankyou

Aftësi të rekomanduara

Punimet mё tё mira nga ky konkurs

Shiko mё shumё vepra

Këndi publik i sqarimeve

  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    Please read project description again

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    Hi Guys, project description has been amended.

    • 5 vite më parë
  • daniyal3214
    daniyal3214
    • 5 vite më parë

    Can you explain what is wrong? Expenses are increased and so debited and liability (Accrued) increased so made credit? I can assure that there is some misunderstanding.

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    Muhammad D. your one is wrong

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    bye

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    wrong

    • 5 vite më parë
  • daniyal3214
    daniyal3214
    • 5 vite më parë

    Also, if there is any payment made for these accruals? Where can I track that from?

    • 5 vite më parë
  • daniyal3214
    daniyal3214
    • 5 vite më parë

    Its completed but you just said that I can use monthly apportionment in sheet 3? But then you just said that sheet 3 might be wrong? Can you tell me which sheet should have accurate data which I can rely on? Its completed from my end by the way. Just confirm this point so I can send you file.

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    you need to find out errors in sheet -3 and then do journals in sheet-1

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    sheet-3 might be wrong, so dont just create journals based on sheet-3

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    there are 3 accounts in total...elec, gas and accrued elec and gas

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    see how its done in sheet-2

    • 5 vite më parë
  • daniyal3214
    daniyal3214
    • 5 vite më parë

    Just one question; would you like to make all the accruals posting as a single account or each accrual must be disclosed separately in entries?

    • 5 vite më parë
  • daniyal3214
    daniyal3214
    • 5 vite më parë

    I am going to upload the file here very soon.

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    sheet-3 has the monthly apportionment calculations, which will help you to make the journal entries in sheet-1

    • 5 vite më parë
  • daniyal3214
    daniyal3214
    • 5 vite më parë

    I don't have the option to bid however, I can only directly submit my entry. I think that is how the contest works here. Correct me if I am wrong. I am a qualified Financial Accountant and have been working with one of the Big 4 Audit firms so this is a really simple stuff for me.

    • 5 vite më parë
    1. naserhossain2018
      Krijuesi i Konkursit
      • 5 vite më parë

      thats fine, just send to me your work

      • 5 vite më parë
    2. naserhossain2018
      Krijuesi i Konkursit
      • 5 vite më parë

      this is financial accounting - accrual accounting

      • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    please bid in contest

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    i posted a contest for $100

    • 5 vite më parë
  • naserhossain2018
    Krijuesi i Konkursit
    • 5 vite më parë

    you can link sheet-1 with sheet-3 with formulas

    • 5 vite më parë
  • daniyal3214
    daniyal3214
    • 5 vite më parë

    Would you prefer automation in journal entries with respect to amount, calculations and/or debt/credit entries? Or you would like to enter data manually?

    • 5 vite më parë

Shfaq më shumë komente

Si të fillosh me konkurset

  • Posto konkursin

    Posto konkursin Shpejt dhe thjeshtë

  • Merr shumë propozime

    Merr shumë propozime Nga e gjithë bota

  • Zgjidh kandidaturën më të mirë

    Zgjidh kandidaturën më të mirë Shkarko dokumentet - E thjeshtë!

Postoni një konkurs tani! ose bashkohu me ne sot!