Effective Bookkeeping

[stpy1027]

I am going to start bookkeeping in October. I will do invoicing, checking the payments, and track expenses and incomes.

There are four projects. And all of them will be sold as service to clients.

I am not sure how I can effectively and simply keep expenses. Because some expenses are charged to all projects and some are charged only one or two projects. Can someone tell me how to keep the split expenses in excel? I would like to know also the total amount of each expense easily too.

In each quarter, I would like to make a simple report to show the revenue and expenses of each project and a summary of all projects combined as the profit of our company.

It would be great if you could help me with examples and charts. Thank you very much!

[allenlondon]

Page 278.

[chelle7272]

https://www.fundera.com/blog/how-to-create-a-bookkeeping-system-in-excel