Grant Management with QuickBooks and Advanced Excel Training Course

Participants can control approved budgets, matching contributions and co-financing commitments throughout a grant period.

• Approved budget converted into coding structure, spending plan and cash forecast
• Matching contribution rules tested for cash, in-kind and third-party support
• Cost share schedules distinguish eligible, committed, claimed and pending contributions
• Budget revisions controlled through version logs, approvals and donor correspondence
• Foreign-currency grant budgets reconciled using transaction, budget and reporting rates
• Burn-rate analysis compares actual spending against time-elapsed budget percentages
• Scenario assumptions quantify funding gaps, delayed receipts and co-financing shortfalls

Participants can configure QuickBooks Online to capture transactions by funder, award, project and cost category.

• QuickBooks Online company settings configured for grant accounting control requirements
• Classes, locations and customer projects assigned to grant reporting dimensions
• Chart of accounts separates restricted funds, income, costs and liabilities
• Products and services used for consistent programme revenue coding
• Custom fields and naming conventions preserve donor and agreement references
• Opening balances and prior-period transactions migrated with audit trails
• User roles restrict posting, approval and report-access permissions

Participants can process grant transactions with sufficient approval, coding and documentary evidence.

• Purchase-to-pay workflow captures approvals, coding, source documents and payment evidence
• Vendor bills allocated across grants using documented allocation bases
• Employee advances, travel claims and liquidations reconciled to grant codes
• Payroll journals distribute salaries, benefits and statutory costs accurately
• Bank feeds matched, reviewed and reconciled without duplicate expense recognition
• Recurring transactions schedule rent, subscriptions and shared service charges
• Correcting journals retain explanations, preparer identity and approval history

Participants can classify grant costs and apply defensible allocation methods to shared expenditure.

• Direct and indirect costs classified against donor eligibility rules
• Allocation bases selected using causality, benefits received and materiality
• Step-down allocation distributes shared services across programmes and grants
• Time-and-effort records support salary charging and cost-share evidence
• Indirect cost rate calculation distinguishes provisional, final and de minimis rates
• Unallowable costs isolated before reimbursement claims and financial reporting
• Cost allocation policy aligns methodology, documentation, review and approvals

Participants can build controlled Excel models that analyse QuickBooks data and identify grant exceptions.

• Excel Tables, structured references and data validation standardise grant workbooks
• XLOOKUP, SUMIFS and COUNTIFS reconcile coding, budgets and transaction extracts
• Dynamic arrays filter exceptions and create refreshable reporting schedules
• Power Query cleans, appends and transforms QuickBooks transaction exports
• PivotTables summarise expenditure by donor, grant, category and period
• Conditional formatting flags overspends, expired budgets and missing documentation
• Formula auditing traces errors through precedents, dependents and calculation settings

Participants can complete a month-end grant close that ties accounting records to management and donor schedules.

• Monthly close checklist sequences bank, payroll, receivable and payable reconciliations
• Grant-to-general-ledger reconciliation identifies timing, coding and completeness differences
• QuickBooks budget-versus-actual reports filtered by class, project and location
• Excel reconciliation matrix ties donor reports to ledger balances
• Deferred income and receivable balances analysed against grant conditions
• Management variance commentary separates timing effects from forecast risks
• Close evidence indexed for reviewer traceability and audit sampling

Participants can prepare accurate donor financial reports and claims supported by reconciled schedules.

• Donor financial report templates mapped to approved budget categories
• Cash-basis and accrual-basis reporting differences reconciled with bridge schedules
• Foreign currency translation schedules document rates, gains and losses
• Supporting schedules substantiate expenditure, match funding and indirect costs
• Report review checks arithmetic, eligibility, period cut-off and narrative consistency
• Submission calendar tracks report due dates, approvals and donor queries
• Amendment requests quantify budget movements and supporting justification

Participants can establish controls and evidence files that support grant compliance reviews and audits.

• COSO control activities adapted for grant receipts, disbursements and reporting
• Audit-ready filing structure links transactions to approvals and source evidence
• Sampling plan tests high-risk transactions, exceptions and repeated control failures
• Fraud indicators reviewed through vendor master, duplicate payments and split purchases
• Data-access controls protect beneficiary, employee and donor information
• Corrective action log assigns owners, deadlines, evidence and closure testing
• Subrecipient monitoring reviews budgets, reports, documentation and corrective actions

Participants can use portfolio indicators and an implementation plan to improve grant-finance performance.

• Grant portfolio dashboard combines budget, actual, forecast and compliance indicators
• Exception thresholds prioritise overspends, late reports and unsupported costs
• Rolling forecast updates receipts, commitments and delivery assumptions monthly
• Funding pipeline analysis distinguishes secured awards from pending proposals
• Month-end calendar assigns preparers, reviewers, deadlines and escalation routes
• 90-day improvement plan sequences QuickBooks, Excel and control enhancements
• Personal action plan defines templates, stakeholders and first reporting cycle