search

sudomesh / quarterlies

How to build quarterly reports for Sudo mesh
1 stars 1 forks source link

Financial reporting #2

Open eenblam opened 5 years ago

eenblam commented 5 years ago
jnny commented 5 years ago

Profit & Loss (called a Statement of Activity in nonprofit world) and Balance Sheet (Statement of Financial Position) are the standard financial reports. The P&L statement's columns are split up by class so we can see the per project breakdown. Current Classes are the standard three 'functional expense' categories reported on the taxes:

  1. Administrative (eg; insurance, incorporation expenses, Quickbooks subscription);
  2. Fundraising (must be low and we don't really spend much on this); and
  3. Program Activities: Program Activities are broken down into 'Community Wireless Network Deployment," ""Educational Workshops," and "Projects" which is subdivided between Disaster Radio and Laptops For All.

Reports can be generated from the Quickbooks and automatically emailed to the finance list every quarter, just like the monthlies.

Sound good? Other kinds of reports might include Projected vs. Actual Budget, income and expense breakdowns by Vendor and Customer, etc;...