WHAT MY DIRECTOR EXPECTS TO SEE ON FINANCIAL SPREADSHEET

by Angel
(South Africa)



Good morning!


My director of finance asked me to create a spreadsheet showing how the business is doing on a weekly base. I created a s-sheet with these columns: consultant name, month, timesheet no., t/s signature, t/s rate, t/s hours, t/s amount, project, invoice no., invoice amount & customer name. He says its not enough and i don't know what is missing, could you please help & tell me what to add? (So the s-sheet reflects the business growth.)

A:
What you've created so far sounds good, but it also sounds like your director wants to see the total income and/or the total profit (or loss) each week. So this is what I would focus on the most. Work out how to show the total income brought in each week. Include the total expenses and a net profit (or loss) figure per week. Ask him if he requires cash inflow and cash outflow figures only, or if he wants income and expenses on credit too (not just cash). Hope that helps.

Click here to post comments

Return to Ask a Question About This Lesson!.






Enjoying this Website?
Help Support it with a Donation

OR...





Advertise on ventoup.ru


Related pages


depreciation accumulated depreciation journal entrybookkeeping ledger templateremove vat calculatorgross profit is equal to sales minuswhat does accrued income meangeneral ledger t accounts templatewhat is a sundry debtordefinition of creditor and debtormanagerial accounting journal entriesfirm meaning in tagalogcross indexing accountingaccounting equestiondebtor reconciliation statementyear end inventory adjustment journal entryhow do i work out vat on a calculatorincome statements for dummiesmerchandise accounting definitiongp percentage calculatorbasic bookkeeping test questionsbalance sheet solved problemstypes of owners equitycapital recieptaccrued expenses meaningdebtors balance sheetaccounting entries for salesprojected financial statement templatesteps in preparing trial balanceonline vat calcwhat is meant by accounts payableaccounting profit equationjournal entry for writing off accounts receivablewhat does ledger balance mean in bankingaccountants trial balanceinventory fifo lifoaccounting for synonymfind ending inventorybest books for accounting beginnerscost ledger control account definitionjournal entry for writing off accounts receivableon a classified balance sheet companies usually list current assetssales and purchase ledger templatedefinition of asset accountinginward synonymcost of goods sold formulasbase stock method of inventory valuationcross indexing in accountingdirect vs indirect laborledger posting and trial balancemerchandise inventory balance sheetdefine debitorsdebits vs credits9 steps of accounting cyclepurchase ledger templateaccounting for owners equityexamples of profit motivesimple aptitude test questions and answersjournals and ledgersmanufacturing overhead formula exampleaccounting journal and ledgercash discount exampleaccounting journals and ledgersexcel vat formuladebtors and creditors ledgerbbf stands forsolved balance sheet problemscashflow statement direct methodpreparing a financial statement worksheetbanking accounting basicspetty cash in balance sheetjournal entry for sales discountaccounting adjusting entries for dummiesdefine sundrydollar markup calculatortrial balance to income statement