Excel & Accounting Expert for Financial Reports
Budget: $10 – $30 USD
I'm seeking an Excel and accounting professional to assist in creating a Balance Sheet and Profit & Loss report.
Excel:
a. In TB sheet, complete the column TB2019 (reminder test balance of one year is the test
balance of previous year with addition of all journal commands).
b. Create new sheet names Balance Sheet and build a report on the financial status based on
the test balances from TB sheet for years 2018 and 2019.
c. In same way, build a profit/loss report.
Note: you have to create the Profit/loss report using SUMIF command and not Pivot table.
Don`t forget to make basic controls – check TB reset and balance between assets to commitments.
Excel:
a. In TB sheet, complete the column TB2019 (reminder test balance of one year is the test
balance of previous year with addition of all journal commands).
b. Create new sheet names Balance Sheet and build a report on the financial status based on
the test balances from TB sheet for years 2018 and 2019.
c. In same way, build a profit/loss report.
Note: you have to create the Profit/loss report using SUMIF command and not Pivot table.
Don`t forget to make basic controls – check TB reset and balance between assets to commitments.