Make journal entries for accrued electricity and gas

  • ステータス: Closed
  • 賞金: $100
  • 受け取ったエントリー: 1
  • 優勝者: Shia5

コンテスト概要

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

推奨スキル

このコンテストのトップエントリー

エントリーをもっと表示

公開説明ボード

  • naserhossain2018
    コンテスト所有者
    • 5年間前

    Please read project description again

    • 5年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

    Hi Guys, project description has been amended.

    • 5年間前
  • daniyal3214
    daniyal3214
    • 5年間前

    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年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

    Muhammad D. your one is wrong

    • 5年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

    bye

    • 5年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

    wrong

    • 5年間前
  • daniyal3214
    daniyal3214
    • 5年間前

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

    • 5年間前
  • daniyal3214
    daniyal3214
    • 5年間前

    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年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

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

    • 5年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

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

    • 5年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

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

    • 5年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

    see how its done in sheet-2

    • 5年間前
  • daniyal3214
    daniyal3214
    • 5年間前

    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年間前
  • daniyal3214
    daniyal3214
    • 5年間前

    I am going to upload the file here very soon.

    • 5年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

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

    • 5年間前
  • daniyal3214
    daniyal3214
    • 5年間前

    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年間前
    1. naserhossain2018
      コンテスト所有者
      • 5年間前

      thats fine, just send to me your work

      • 5年間前
    2. naserhossain2018
      コンテスト所有者
      • 5年間前

      this is financial accounting - accrual accounting

      • 5年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

    please bid in contest

    • 5年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

    i posted a contest for $100

    • 5年間前
  • naserhossain2018
    コンテスト所有者
    • 5年間前

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

    • 5年間前
  • daniyal3214
    daniyal3214
    • 5年間前

    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年間前

コメントをもっと見る

コンテストの開始方法

  • あなたのコンテストを投稿

    あなたのコンテストを投稿 速くて簡単

  • たくさんのエントリーを集めましょう

    たくさんのエントリーを集めましょう 世界中から

  • ベストエントリーをアワード

    ベストエントリーをアワード ファイルをダウンロード - 簡単!

コンテストを今すぐ投稿 または本日参加!