Nonprofit finance, plainly

Your grant report is due and you cannot produce the numbers.

The report is open, the deadline is close, and you are trying to answer a question that should have been simple: what did we spend this grant on? You may have invoices, payroll reports, and bank transactions, but not a clean number you can stand behind. This is fixable, even if the first report takes more work than it should.

First, the honest version

A grant report is usually not asking whether your organization spent money in general. It is asking whether you spent this particular grant’s money on the activities, time period, and expense categories the funder approved.

Funders often check a few things first. They compare the total spending you report to the grant budget. They look for expenses that fall outside the grant period, meaning the dates when grant funds were allowed to be used. They review whether the costs match the approved purpose of the grant. They may also compare your financial report to your program narrative, which is the written description of what your organization accomplished.

Some funders request supporting documentation. That can include invoices, payroll records, timesheets, receipts, contracts, or proof that payments cleared the bank. Others may ask for a more detailed accounting report later, even if the initial report only asks for category totals.

The immediate risk is usually that you submit numbers you cannot support. A rushed estimate can create a harder problem later if the funder asks follow-up questions, if your board reviews the grant, or if the same grant information is used in an audit or financial statement.

The second risk is missing eligible spending. You may have spent more on the grant than you realize, but if staff time, supplies, contractor costs, or program expenses were never tagged to the grant, they are difficult to find now.

Neither problem means your organization has failed. It means your accounting system was not set up to answer grant questions as work happened. Many small nonprofits start with general bookkeeping that can show total revenue and expenses, but cannot easily show which expenses belong to which restricted funding source.

Restricted funding means money a donor or funder has designated for a specific purpose. The restriction may be broad, such as “youth programming,” or narrow, such as a particular project during a particular year. Your organization still needs to track the restriction even after the money arrives in your bank account.

What to do this week

Start with the grant agreement, not the accounting software. Pull together the award letter, approved budget, reporting instructions, payment schedule, and any emails that changed the terms. Make a one-page summary with four columns: approved expense categories, grant period, reporting deadline, and required attachments.

Then build a reconstruction worksheet. A reconstruction is the process of identifying past transactions and assigning them to the correct grant after the fact. Create columns for date, vendor or employee, description, amount, grant budget category, source document, and notes.

Use your bank transactions, credit card statements, vendor invoices, payroll reports, and reimbursement records to identify likely grant expenses. Work category by category instead of trying to review everything at once. If the grant funded supplies, begin with supply vendors. If it funded a contractor, begin with the contract and payment records. If it funded staff time, begin with payroll.

Payroll often requires the most careful review. If staff members worked partly on the grant and partly on other activities, do not guess at a percentage because it seems reasonable. Look for calendars, project plans, meeting notes, timesheets, supervision notes, or other records that can support how time was allocated. Allocated means divided among more than one program, grant, or activity.

Keep a clear record of your method. If you identify a cost based on a particular invoice, save the invoice. If you use a reasonable basis to allocate staff time, write down the basis. You are not trying to create a perfect historical system. You are creating a report that is honest, organized, and supported by available records.

Before you submit, compare your reconstructed totals to the approved grant budget. A difference is not automatically a problem. Many funders allow some movement between categories, while others require prior approval. Read the agreement before moving costs around simply to make the report look balanced.

If you cannot support a number, do not hide that fact from yourself. Flag it. You may need to report a lower amount, request an extension, ask the funder a clarifying question, or return unspent funds. Those are management decisions, not personal failures.

The structural fix

Well-built nonprofit books make grant reporting part of regular monthly accounting, not a separate emergency project. Each transaction is recorded with the information needed to answer future questions.

The key tool is often a class structure. A class is an accounting label attached to income and expenses so you can sort financial activity by program, grant, location, or other meaningful category. In many accounting systems, you can run a report by class to see the activity connected to a specific grant.

For grant tracking, the structure should be simple enough that staff can use it consistently. You may need a class for each major program, a separate grant label for significant restricted awards, and clear rules about which costs belong where. You also need a process for payroll allocation, meaning a documented way to assign employee compensation across grants and programs.

A good monthly close helps make this reliable. Month-end close is the routine process of reconciling bank and credit card accounts, reviewing transactions, recording payroll and other activity, and producing financial reports after each month ends. The free Month-End Close Checklist can help you see what should happen before grant reporting season arrives.

If you are not sure whether your current setup can produce clean grant reports, the Nonprofit Financial Health Check is a practical place to start. It is a $500 fixed-fee assessment of ten operational areas, delivered as a written report your board can read. The full fee is credited toward the first month of any engagement. It can help you identify whether the issue is your chart of accounts, class structure, payroll process, month-end close, document storage, or reporting workflow.

The goal is not a more complicated system. It is a system where the next grant report is a ten-minute export, followed by a thoughtful review, instead of a late-night reconstruction.

Millennial M&C Co. provides nonprofit accounting and operational support. We prepare and present; your CPA files. Nothing here is tax or legal advice for your specific situation.