Income Statement

[TKnTexas]

I am not looking to reinvent an accounting program as such.  I am want to create the tracking tools in Filemaker Pro that I have been using in Excel.   It is taking information from several sources in a restaurant to complete the tracking "worksheets". 

 

There is sales tracking and labor tracking.  Invoices are tracked to collect the purchases for cost of goods sold as well as the other expenses.  On a weekly basis or sometimes 10 day/20 day/EOM a proforma income statement is prepared.  I have all of the information in tables.  Now it is just a matter of assembling an income statement.  For those that have done that, can you give me a hint? 

 

Do I create a record definition, that is field for each line of the income statement?  This is the only schema that I can see... but hence the need for a hint.

[LaRetta]

Hi Thomas,

If established properly, all you should require is a summarized, grouped report with leading parts based upon your highest level, then your next highest sort by same order. If you have assigned GL numbers and use a GL to designate separation it will be simple otherwise just use your 'tier' fields such as Category, Type etc.

Have you created grouped reports before? We would need to know your setup to be more specific.

Do I create a record definition, that is field for each line of the income statement?

Oh, no, do not do this. A field for each line of the same 'anything' is indication of problem and not solution. :-)

ADDED ... for this report you end up deleting the body after you build it, putting the summary field(s) into the leading part along with the field it is grouping on.

[TKnTexas]

I have created group reports.  I can see sales group, costs of sales group, payroll group, and other expenses.  What I am missing is the Gross Operating Profit line which would be sales - costs of sales.  Or gross operating income which Gross Operating Profit less Operating Expenses.  I will ponder it some more.

[LaRetta]

It is hard to say without seeing the file.  If you can zip and attach that's ideal or create a bare, single file with just those fields and calcs and the three (or more?) tables involved.  :^)

[TKnTexas]

This is mock-up of the larger file I am working on.  The InvoLog is a file of invoices owed.  The child file (InvoLogDistr) has the GL distribution detail per invoice.  At the end of the week the distribution is imported to the GLTran file.  The sales transactions would be entered directly to the GLTrans file. 

 

So the CoA (Chart of Account) table has the GL accounts, and the report line that they total into.  If I have not been clue enough let me know.

[TKnTexas]

I am not able to upload my *.fm12 file

 

I am not permitted to upload this kind of file

[doughemi]

Zip it and then you can upload it.

[TKnTexas]

The GLTran Table would be the source of the info to build the Income Statement.  I would import expense info from the InvoLogDetail while entering sales data directly.

 

Thanks for upload tip

I got it this time.

CoA.fmp12.zip