Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 24 views

    Week 2 Excel Assignment

    Uploaded by

    adomahattafuah
    The document contains accounting transactions for Price Corporation for the period ending December 31, 20xx. It records cash receipts and payments, purchases and sales on account, expenses incurred, and dividends paid. A trial balance and post-closing trial balance are provided that equal, indicating accurate accounting records.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Week 2 Excel Assignment

    Uploaded by

    adomahattafuah
    24 views8 pages
    The document contains accounting transactions for Price Corporation for the period ending December 31, 20xx. It records cash receipts and payments, purchases and sales on account, expenses incurred, and dividends paid. A trial balance and post-closing trial balance are provided that equal, indicating accurate accounting records.

    Original Description:

    Original Title

    week 2 excel assignment

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains accounting transactions for Price Corporation for the period ending December 31, 20xx. It records cash receipts and payments, purchases and sales on account, expenses incurred, and dividends paid. A trial balance and post-closing trial balance are provided that equal, indicating accurate accounting records.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    24 views8 pages

    Week 2 Excel Assignment

    Uploaded by

    adomahattafuah
    The document contains accounting transactions for Price Corporation for the period ending December 31, 20xx. It records cash receipts and payments, purchases and sales on account, expenses incurred, and dividends paid. A trial balance and post-closing trial balance are provided that equal, indicating accurate accounting records.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 8

    Date Account Dr Cr Date

    01/01/20x Cash 25000 01/09/20x


    Common Stock 25000

    Date Account Dr Cr Date


    01/03/20x Prepaid 8400 09/09/20x
    Cash 8400

    Date Account Dr Cr Date


    14/04/20x Supplies 400 02/11/20x
    Account Payable 400

    Date
    Date Account Dr Cr 31/12/20x
    30/06/20x Cash 12,000
    Unearned revenue 12,000

    Date
    Date Account Dr Cr 31/12/20x
    05/07/20x Account Payable 300
    Cash 300

    Date Account Dr Cr 31/12/20x


    01/08/20x Account Receivable 24,800
    Service revenue 24,000

    31/12/20x
    Account Dr Cr
    Salaries exprense 18,000
    Cash 18,000

    Account Dr Cr
    Cash 4,250
    Account receivables 4,250

    Account Dr Cr
    Dividend 500
    Cash 500

    Account Dr Cr
    Unearned revenue 6,000
    Service Revenue 6,000

    Account Dr Cr
    Salaries Expense 1,100
    Salaries Payable 1,100

    Account Dr Cr
    Rent Expense 4,200
    Prepaid Rent 4,200

    Account Dr Cr
    Supplies Expense 350
    Supplies 350
    _______Cash______ _______Salary Payable______
    01/01/20x 25000 31/12/20xx 1100
    01/03/20xx 8400
    30/06/20x 12000 Bal 1100
    05/07/20xx 300
    01/09/20xx 18000
    09/09/20x 4250
    02/11/20xx 500
    Bal 14050

    _______Account Receivable______ _______Unearned revenue______


    01/08/20x 24800 30/06/20xx 12000
    09/09/20xx 4250 31/12/20x 6000

    Bal 20550 Bal 6000

    _______Supplies______ _______Prepaid Rent______


    14/04/20x 400 01/03/20x 8400
    31/12/20xx 350 31/12/20xx 4200

    Bal 50 Bal 4200

    _______Dividend______ _______Revenue______
    02/11/20x 500 01/08/20x 24800
    31/12/20x 6000
    Bal 500
    Bal 30800

    _______Supplies Expense______
    31/12/20x 350 _______Salary Expense______
    01/09/20x 18000
    Bal 350 31/12/20x 1100

    Bal 19100
    _______Account payable______
    400 14/04/20xx
    300 05/07/20xx
    Bal 100

    _______Common Stock______
    25000 01/01/20xx

    Bal 25000

    _______Retained Earnings______

    _______Rent Expense______
    31/12/20x 4200

    Bal 4200
    ____Salary Expense______
    Price Corporation
    Trial Balance
    December 31, 20xx

    Dr Cr
    Cash 14050
    Accounts Receivable 20550
    Supplies 50
    Prepaid Rent 4200
    Salary Payable 1100
    Accounts Payable 100
    Unearned Revenue 6000
    Common Stock 25000
    Retained Earnings
    Dividend 500
    Revenue 30800
    Rent Expense 4200
    Supplies Expense 350
    Salary Expense 19100

    Total 63000 63000


    Price Corporation
    Post Closing Trial Balance
    December 31, 20xx

    Dr Cr
    Cash 14050
    Accounts Receivable 20550
    Supplies 50
    Prepaid Rent 4200
    Salary Payable 1100
    Accounts Payable 100
    Unearned Revenue 6000
    Common Stock 25000
    Retained Earnings 6650
    Dividend
    Revenue
    Rent Expense
    Supplies Expense
    Salary Expense

    Total 38850 38850

    You might also like