Tutorial: Administrative Expense Allocation

1. Overview

In this tutorial you will build a workflow that takes a list of administrative expenses and allocates them across departments using allocation schedules. IT costs get allocated by headcount, facility costs by square footage, and shared services by revenue. The workflow produces a journal entry ready to post to QuickBooks Online or any GL system.

You won't write any code. You'll paste four data files into your workspace, describe what you want, and let the app build and run the workflow.

What you'll end up with:

• A workflow that allocates admin expenses to departments automatically
• An allocation detail report showing how each expense was distributed
• A journal entry in debit/credit format ready for GL posting
• A saved .wfp file you can re-run each month with updated numbers

Time: About 15 minutes.

Skip to result: Download the finished expense_allocation.wfp and open it in the app to see the completed workflow without building it yourself.

2. Background

Why this matters

Every month, the accounting team has to allocate shared costs — IT support, rent, utilities, insurance, HR — across the departments that benefit from them. Each cost pool uses a different allocation basis:

• IT costs are allocated by headcount (more people = more IT support needed)
• Facility costs are allocated by square footage (more space = more rent/utilities)
• Shared services like HR and admin are allocated by department revenue (larger departments absorb more overhead)

In a spreadsheet, this means maintaining multiple allocation tables, writing VLOOKUP formulas across sheets, manually calculating percentages, and building the journal entry row by row. It's tedious and error-prone — one wrong percentage and the entire allocation is off.

What the workflow does instead

You give the app four data files: the expenses to allocate, a headcount schedule, a square footage schedule, and a revenue schedule. The workflow reads the allocation basis for each expense, calculates the department percentages, distributes the amounts, and produces a journal entry you can import directly.

When next month's expenses come in, update the numbers and run the same workflow again.

About the sample data

The sample data represents one month of administrative expenses for a mid-sized company with four operating departments: Sales, Marketing, Manufacturing, and R&D. There are 12 expense items totaling $87,500 across three allocation pools (IT, Facility, Shared Services). The allocation schedules reflect realistic proportions — Manufacturing has the most floor space, Sales has the most revenue, R&D has the most headcount per dollar.

3. Sample Data Files

Paste the name and data into User Data on the main app page.

admin_expenses

admin_expenses

expense_id,description,amount,cost_pool,gl_account
EXP-001,IT Help Desk Support,12000.00,IT,7100
EXP-002,Network & Server Maintenance,8500.00,IT,7100
EXP-003,Software Licenses (Enterprise),6000.00,IT,7110
EXP-004,Building Rent,18000.00,Facility,7200
EXP-005,Utilities - Electric & Gas,4200.00,Facility,7210
EXP-006,Building Insurance,2800.00,Facility,7220
EXP-007,Janitorial Services,3500.00,Facility,7230
EXP-008,HR Department Salaries,15000.00,Shared,7300
EXP-009,General Admin Staff,8000.00,Shared,7310
EXP-010,Corporate Insurance,4500.00,Shared,7320
EXP-011,Accounting & Audit Fees,3500.00,Shared,7330
EXP-012,Office Supplies - Common,1500.00,Shared,7340

headcount_schedule

headcount_schedule

department,headcount,dept_code
Sales,18,D100
Marketing,12,D200
Manufacturing,25,D300
R&D,15,D400

sqft_schedule

sqft_schedule

department,square_feet,dept_code
Sales,4000,D100
Marketing,3000,D200
Manufacturing,12000,D300
R&D,6000,D400

revenue_schedule

revenue_schedule

department,monthly_revenue,dept_code
Sales,850000,D100
Marketing,320000,D200
Manufacturing,1200000,D300
R&D,180000,D400

4. How the Allocation Works

Each expense is assigned to a cost pool that determines which allocation basis to use:

For example, IT Help Desk Support ($12,000) is in the IT pool, allocated by headcount:

Building Rent ($18,000) is in the Facility pool, allocated by square footage:

5. Building the Workflow

On the workflow page, click + New Workflow and paste:

I have admin_expenses, headcount_schedule, sqft_schedule, and revenue_schedule in my workspace. Build me a workflow that allocates each admin expense to departments. IT pool expenses are allocated by headcount, Facility pool by square footage, and Shared pool by revenue. Produce an allocation detail report showing how each expense was distributed, and a journal entry in debit/credit format that I can post to a GL system. The journal entry should debit each department's expense account and credit the admin expense clearing account (9900).

The AI shows you a plan — review it and click Approve.

6. Checking Your Results

Allocation detail report

Open the report and verify:

• 12 expenses are listed, each broken into 4 department rows (48 allocation rows total)
• IT pool (EXP-001 through EXP-003): percentages should match headcount ratios — Sales 25.7%, Marketing 17.1%, Manufacturing 35.7%, R&D 21.4%
• Facility pool (EXP-004 through EXP-007): percentages should match square footage ratios — Sales 16.0%, Marketing 12.0%, Manufacturing 48.0%, R&D 24.0%
• Shared pool (EXP-008 through EXP-012): percentages should match revenue ratios — Sales 33.3%, Marketing 12.5%, Manufacturing 47.1%, R&D 7.1%
• Each expense totals correctly — the four department amounts should sum to the original expense amount
• Grand total remains $87,500.00

Journal entry

The journal entry should have:

• Debit entries: one per department per expense, coded to the department code (D100-D400) and the expense GL account
• Credit entries: one per expense, crediting account 9900 (Admin Expense Clearing) for the full expense amount
• Total debits = Total credits = $87,500.00
• Each line shows: date, account, department, description, debit or credit amount

Example lines:

2025-03-31  7100  D100  IT Help Desk Support - Sales         $3,085.71 DR
2025-03-31  7100  D200  IT Help Desk Support - Marketing     $2,057.14 DR
2025-03-31  7100  D300  IT Help Desk Support - Manufacturing $4,285.71 DR
2025-03-31  7100  D400  IT Help Desk Support - R&D           $2,571.43 DR
2025-03-31  9900        IT Help Desk Support                $12,000.00 CR

If something doesn't look right

• "The percentages for IT allocation look wrong" — ask the chat to fix it
• "Can you round all amounts to 2 decimal places and handle the rounding difference on the largest department?" — this is a common accounting requirement
• "Add a column showing the allocation basis amount (headcount/sqft/revenue) for each department"

7. Posting to a GL System

The journal entry output is designed for import. Depending on your GL system:

• QuickBooks Online: Copy the journal entry data into QBO's Import Journal Entries template (CSV format)
• Built-in GL: If you have the GL tools set up in your workspace, you can ask the chat to add a step that posts the journal entry directly using gl_post
• Other systems: Export the journal entry as CSV and format it to match your system's import template

To add GL posting to the workflow, tell the chat:

"Add a step at the end that posts this journal entry to the General Ledger using gl_post"

8. Saving Your Work

When you're happy with the results:

1. Go to Workspace → User Data
2. Click Export .wfp to save everything
3. Next month, update the admin_expenses file with new amounts and run the same workflow again
4. If headcount, square footage, or revenue changes, update those schedules too

What's Next

Once you're comfortable with this workflow, try these ideas:

• Add a fifth allocation basis — maybe some costs should be allocated equally (flat split), not by any metric
• Multi-level allocation — first allocate IT to departments, then re-allocate some of IT's cost to specific projects
• Budget comparison — add a budget file and produce a variance report showing actual vs budgeted allocations
• Automated rounding — ensure the allocated amounts round correctly and any penny differences land on the largest department (a standard accounting practice)
• Department P&L impact — combine the allocations with each department's direct expenses to show fully-loaded departmental P&L statements