Skip to content
Workflow · Finance close · Opening soon

Statement of functional expenses

Export your expense report by account and your functional expense allocation table from QuickBooks, then load both files into the workflow. It matches accounts, applies your allocation percentages, and calculates the program, management and general, and fundraising totals.

Early access opens shortly. Check back soon.

Someone typed

“build the functional expenses statement from our quickbooks expense report and allocation table, split each account into program, management and general, and fundraising, show agrees when the three pieces add to the total, check allocation when an account has no split, misallocated when fundraising share is over 10%”

The agent read it as

Build the functional expenses statement from our QuickBooks expense report by account and QuickBooks functional expense allocation table, split each account into program, management and general, and fundraising, show agrees when the three pieces add to the total, check allocation when an account has no split, misallocated when fundraising share is over 10%.

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    QuickBooks expense report by account
    CSV export · 15 rows
  2. File
    QuickBooks functional expense allocation table
    CSV export · 15 rows
  3. Step
    Make expense account key
    Step 1
  4. Step
    Make allocation account key
    Step 2
  5. Join
    Add account allocations
    15 of 15 paired
  6. Step
    Calculate functional expenses
    Step 4
  7. Result
    Functional Expense Statement
    15 rows · 2 flagged
  8. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 15 rows came out, and the join paired 15 of 15 rows.

What you get back

The result of that run, the rows to look at first.

Functional Expense StatementSample data15 rows
13 agrees2 misallocated
AccountStatusProgram expenseManagement and general expenseFundraising expenseTotalProgram shareManagement and general shareFundraising share
Marketing and outreachMisallocated7,1904,31417,25628,76025%15%60%
Bank and merchant feesMisallocated3,4201,3682,0526,84050%20%30%
Payroll and benefitsAgrees149,23227,9819,327186,54080%15%5%
Program suppliesAgrees45,799.501,446.30964.2048,21095%3%2%
Client service contractorsAgrees67,693.604,414.801,471.6073,58092%6%2%
OccupancyAgrees29,8558,5304,26542,65070%20%10%
Office suppliesAgrees6,6774,2491,21412,14055%35%10%
Travel and conferencesAgrees16,4731,93896919,38085%10%5%
Software subscriptionsAgrees14,8466,8521,14222,84065%30%5%
Professional feesAgrees12,56817,2811,57131,42040%55%5%
Training and developmentAgrees7,5271,7373869,65078%18%4%
InsuranceAgrees9,2585,400.50771.5015,43060%35%5%
15 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Functional Expense Statement workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Functional Expense Statement: questions

How do you build a statement of functional expenses?
Export your expense report by account and your functional expense allocation table from QuickBooks, then load both files into the workflow. It matches accounts, applies your allocation percentages, and calculates the program, management and general, and fundraising totals. It also shows when the split adds back to the original total and flags accounts that need review.
Which export should you use?
Use the exported expense report by account and the exported allocation table. The workflow reads spreadsheet-style files, so export them in a format it can import, such as CSV or XLSX.
What happens to rows that do not match?
Rows that do not match an allocation rule are left for review. You can see which account did not match and which rows need a rule or a correction.
How do you change the rules?
Change the rule in words by editing the matching key or the allocation percentages. You can make the rule broader or narrower, then run the workflow again on the exported files.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →