Tracking Customers and Vendors for Grants

QuickBooks Customers and Vendors play important roles in grant management. Here's how to set them up effectively with GrantLink.

Customers in Grant Management

Using Customers for Funders

Some organizations use QuickBooks Customers to represent funders:

Advantages:

• Track A/R by funder when receivables are actually posted to Accounts Receivable and assigned to that Customer
• See payment history
• Generate funder-specific reports in QuickBooks

Setup:

1. Create a Customer for each funder
2. Assign relevant sales forms and A/R activity to that Customer
3. On the relevant GrantLink Funder record, link the QuickBooks Customer when appropriate

Using Customers for Grants

Alternatively, use Customers directly for grants:

When to use this approach:

• You want to track grants as "jobs" in QuickBooks
• Your team is familiar with the Customer/Job model
• You need Customer-based reporting in QuickBooks

Configuration in GrantLink:

1. Add the grant manually or from its PDF
2. On that grant, link the applicable Customer, sub-customer/job, Project, Location, or Class under Expenses
3. Configure Money received links separately when a QuickBooks income/revenue tracking value identifies grant revenue

Vendors in Grant Management

Why Vendor Tracking Matters

Accurate vendor tracking helps with:

• Form 1099 reporting
• Consultant fee monitoring
• Procurement compliance
• Audit documentation

Vendor Setup Best Practices

1. Complete vendor information

   • Legal name (for 1099s)
   • Tax ID
   • Address
   • Payment terms

2. Use vendor types

   • Consultant
   • Subcontractor
   • Supplier
   • Government

3. Track by grant when needed

   • Some grants require vendor-specific reporting
   • Use memos or custom fields for grant references

Linking Vendors to Grants

Vendor selection alone does not establish a grant allocation. Grant attribution comes from the grant's QuickBooks links and the resulting allocation review:

1. Enter a bill or expense in QuickBooks
2. Assign the vendor and the organization's applicable Customer/Project/Class or other tracking value
3. Confirm that tracking value is linked under the grant's Expenses links
4. Review the synced line and its allocation or budget-line coding as needed

Synced vendor data can be reviewed and filtered with transaction detail in Ledger and Allocations. Use QuickBooks for authoritative vendor, payment, and 1099 reporting.

Projects and Sub-Customers

Projects are currently included in Plus and Advanced; verify Intuit's plan page because packaging can change:

Projects are distinct from sub-customers/jobs. Each Project has one Customer, while sub-customers are Customer-list records in a hierarchy.

Using Projects for Grants

1. Create a Customer for the funder
2. Create each Project for that Customer
3. Track time and expenses to Projects

Benefits:

• Hierarchical organization
• Project profitability reports
• Time tracking integration

GrantLink Integration

Link a Project to an individual grant through that grant's QuickBooks links. The QuickBooks Online hierarchy does not automatically create GrantLink funder or grant records; add and maintain those records explicitly. QuickBooks Online Projects support project costing and profitability workflows, while the approved funder budget belongs in the grant's Budget area and may use different categories and dates.

Best Practices

For Funders/Customers

1. Use consistent naming conventions
2. Keep contact information current
3. Set up payment terms
4. Track communication history

For Vendors

1. Obtain Form W-9 when required by the organization's vendor-onboarding and information-reporting policy
2. Set up 1099 tracking
3. Document vendor qualifications
4. Maintain contracts on file

For Projects

1. Match project names to grants
2. Reconcile project costing with the separately maintained grant budget
3. Track to project deadlines
4. Archive completed projects

Troubleshooting

Vendor Not Appearing in GrantLink

• Inspect the source transaction in QuickBooks and confirm its vendor/payee and supported transaction detail
• Check that the transaction is within the synced period and that the last sync succeeded
• After correcting QuickBooks, sync again and review the line in Ledger or Allocations

Customer/Funder Mismatch

• Open the relevant Funder record in GrantLink
• Ensure the correct QuickBooks Customer is linked there
• Keep per-grant expense and revenue matching links on the applicable grant

How GrantLink supports this today

After adding a grant manually or from its PDF, use the grant's Expenses and Money received QuickBooks links to select applicable Customers, sub-customers/jobs, Projects, Locations, or Classes. Eligible matching expense lines can auto-allocate; vendor identity and budget-line coding remain separate facts and may require review. GrantLink does not require one organization-wide tracking type, and QuickBooks remains the accounting source of truth.

GrantLink does not rewrite QuickBooks Online automatically; shared account mappings are restricted-account mappings only. Reports start in Chats > New Chat.

Sources

• Intuit: Create projects — current Projects plans, setup, and Customer relationship.
• Intuit: Add a new customer — customers and sub-customers.
• IRS: Instructions for Forms 1099-MISC and 1099-NEC — authoritative filing rules; QuickBooks Online vendor flags do not determine federal filing obligations.