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
    콘테스트 주최자
    • 3 개월 전

    Please read project description again

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

    Hi Guys, project description has been amended.

    • 3 개월 전
  • daniyal3214
    daniyal3214
    • 3 개월 전

    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.

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

    Muhammad D. your one is wrong

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

    bye

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

    wrong

    • 3 개월 전
  • daniyal3214
    daniyal3214
    • 3 개월 전

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

    • 3 개월 전
  • daniyal3214
    daniyal3214
    • 3 개월 전

    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.

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

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

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

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

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

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

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

    see how its done in sheet-2

    • 3 개월 전
  • daniyal3214
    daniyal3214
    • 3 개월 전

    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?

    • 3 개월 전
  • daniyal3214
    daniyal3214
    • 3 개월 전

    I am going to upload the file here very soon.

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

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

    • 3 개월 전
  • daniyal3214
    daniyal3214
    • 3 개월 전

    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.

    • 3 개월 전
    1. naserhossain2018
      콘테스트 주최자
      • 3 개월 전

      thats fine, just send to me your work

      • 3 개월 전
    2. naserhossain2018
      콘테스트 주최자
      • 3 개월 전

      this is financial accounting - accrual accounting

      • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

    please bid in contest

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

    i posted a contest for $100

    • 3 개월 전
  • naserhossain2018
    콘테스트 주최자
    • 3 개월 전

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

    • 3 개월 전
  • daniyal3214
    daniyal3214
    • 3 개월 전

    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?

    • 3 개월 전

이용 후기 더 보기

콘테스트를 시작하는 방법

  • 콘테스트를 게시하세요

    콘테스트 게시하기 빠르고 쉽습니다

  • 수많은 항목을 입찰받으세요

    수많은 항목을 입찰받으세요 전세계 프리랜서들이 입찰합니다

  • 최고 항목에 수여하기

    최고 항목에 수여하기 파일을 다운로드하세요 - 쉽습니다!

지금 콘테스트 게시 아니면, 오늘 바로 시작하세요!