I have a beer importing business in China and want to make my financial statements for the years 2016 and 2017 (Cash flow Statement, Income Statement, Balance Sheet). The documents need to be prepared in excel.
1. I have an excel file called Income & Expenses listing all transactions from August 2015 to September 2017 , as well as an overview of the current inventory of beer on stock.
2. The job requires you to use this data to prepare the Cash Flow Statement, Income Statement and Balance Sheet. Showing the results for the year ending September 2017.
3. I also need a Working Capital Sheet showing all cash in and outflows on a monthly basis for the period starting August 2015 till September 2017. I attached the templates for the Working Capital Sheet and the Profit & Loss Sheet to this message. Basically it means you need to just group all transactions that occurred within a specific month. For example all Shipping costs that occurred during January 2016 should be grouped together for January 2016. When you open the templates everything should become clear.
Our business is a middle size company, with not a lot of transactions, meaning these financials statements should be relatively easy and fast to prepare. In all I think it should take no longer than 3 hours.
66 freelancer đang chào giá trung bình $3754 cho công việc này
Prepare Financial Statements for 2017 (Small Size Company). Relevant Skills and Experience Accounting, Excel, Finance, Financial Analysis Proposed Milestones $3333 HKD - m