Knowledge Base

Grain Ledger User Guide

Looking for an overview of everything the Grain Ledger integration can do? Visit our Grain Ledger Integration page for a full feature summary, use cases, and getting started information.


Grain Ledger Integration: Complete Administration Guide

If your church uses Grain Ledger for fund accounting, the OnlineGiving.org integration keeps your books up to date automatically. Every donation processed through OnlineGiving.org—whether it’s a one-time gift, a recurring tithe, a scanned check, or a DAF contribution—flows into Grain Ledger as an individual contribution without anyone lifting a finger. Donors are matched, funds are mapped, gifts are grouped into batches, and bank deposit settlements are created so your treasurer can reconcile by reviewing rather than re-keying.

Grain Ledger is an accounting platform, not a church management system. That means this integration runs alongside Planning Center, Ministry Platform, Rock RMS, or whatever ChMS your church already uses. The same gift records to your ChMS for pastoral care and to Grain Ledger for the books—both running side by side, never interfering.

Why Automated Accounting Matters for Your Church

Think about what happens after a week of online giving without automation. Someone downloads a report, cross-references donor names, manually enters each gift into the ledger, groups them into a batch, and then tries to match the batch total to what the bank deposited. For a church processing hundreds of gifts per week, that’s hours of administrative work—and a recipe for errors that surface at audit time.

With the OnlineGiving.org Grain Ledger integration, all of that happens automatically. Contributions post in real time as gifts are approved. The system matches donors to existing Grain Ledger records, maps each gift to the correct fund, splits cover-the-fee amounts into their own contribution, classifies DAF and QCD gifts correctly, groups everything into giving batches, and files a bank deposit settlement showing exactly what your bank will deposit. If something fails, the system retries automatically and alerts your team.

Beyond Basic Recording

What sets this integration apart from most accounting connections is depth. It doesn’t just push gift amounts into a ledger—it pushes the full picture. Each contribution carries the donor, the fund, the payment method, and the amount. Donor-advised fund gifts and qualified charitable distributions are classified with the correct source type so your year-end giving statements are accurate without anyone remembering to flag them. Refunds flow back automatically, and if a refund touches a closed accounting period, your treasurer gets an alert instead of a silent error.

Bank deposit settlements are the piece most accounting integrations skip entirely. When a giving batch closes, OnlineGiving files a settlement in Grain Ledger with the giving total, payment count, and estimated arrival date. Your treasurer opens Grain Ledger and finds the deposit expectation already waiting.

One-Click Connection, Always Monitored

Connecting is one click—your admin clicks a button, authorizes in Grain Ledger, and the connection is live. No API keys to paste, no passwords to share. The connection refreshes itself, and OnlineGiving monitors integration communications 24/7/365 with automatic retries for any failed events.

In this article, we’ll overview every administrative feature of the OnlineGiving.org Grain Ledger integration and how to use each one from your control panel.

Grain Ledger User Guide:


The Grain Ledger Integration connects your OnlineGiving.org account to Grain Ledger’s fund accounting platform with a secure one-click connection. Once connected, donations are recorded as individual contributions automatically, donors and households are matched, funds are mapped, gifts are grouped into batches, and bank deposit settlements are filed for reconciliation. This guide covers every feature available in your control panel.

Key Takeaways

  • Real-Time Contribution Recording: Every approved donation posts to Grain Ledger individually with the donor, fund, amount, fee, and payment method—no manual entry required.
  • Donor and Household Matching: A four-step waterfall matches donors by external ID, email, name, and phone before creating new records. Households sync with primary, spouse, and children.
  • Giving Batches: Gifts are grouped into batches that mirror your bank deposits, with totals derived automatically from the contributions inside.
  • Bank Deposit Settlements: Each closed batch files a settlement with the giving total, payment count, and estimated arrival date.
  • DAF and QCD Classification: Donor-advised fund and qualified charitable distribution gifts are classified automatically for accurate year-end statements.
  • Cover-the-Fee Splitting: When configured, the covered fee posts as a separate contribution to a designated fund.
  • Refund Sync: Refunds flow to Grain Ledger automatically. Closed-period refunds create a treasurer alert instead of silently failing.
  • Runs Alongside Your ChMS: Uses dedicated fields—does not conflict with Planning Center, Ministry Platform, Rock RMS, or any other integration.

Table of Contents

  1. Getting Started
  2. Fund Mapping
  3. Donor and Household Matching
  4. Contribution Recording
  5. Giving Batches and Bank Settlements
  6. Refund Handling
  7. Settings Reference
  8. Running Alongside Your ChMS
  9. Frequently Asked Questions

Getting Started

Connecting to Grain Ledger

  1. Log in to the control panel.
  2. Navigate to Settings > Giving Settings.
  3. Scroll to the Grain Ledger section.
  4. Click the “Connect to Grain Ledger” button.
  5. You’ll be redirected to Grain Ledger’s authorization page. Sign in with your Grain Ledger credentials and authorize OnlineGiving.org.
  6. After authorizing, you’ll be redirected back to your control panel. The connection is now active.

The system automatically resolves your Grain Ledger organization and stores the connection securely. No API keys or passwords are needed. The connection refreshes itself automatically—you should never need to reconnect unless you deliberately disconnect.

Disconnecting

  1. Navigate to Settings > Giving Settings.
  2. Click “Disconnect Grain Ledger”.
  3. All stored tokens and organization links are cleared immediately.

Disconnecting stops all future recording but does not remove contributions, batches, or settlements already in Grain Ledger. Your existing data in both systems is preserved.


Fund Mapping

How to Map a Fund

  1. Navigate to Giving > Funds.
  2. Click “Edit” on the fund you want to map.
  3. In the Grain Ledger Fund dropdown, pick the matching fund from your Grain Ledger account.
  4. Click “Save”.

The dropdown is loaded live from Grain Ledger, so you choose by name rather than copying an ID. To keep a fund out of Grain Ledger entirely—such as an internal test fund or pass-through account—choose “Do not Record Fund into Grain Ledger.” Gifts to that fund will be skipped cleanly rather than generating errors.

If you see a text field instead of a dropdown, paste the Grain fund ID. Open the fund in the Grain Ledger control panel and copy the ID from the browser URL, for example app.grainledger.com/accounting/funds/cmtsowqei04rq0ioadqc3p1zo. Enter N/A to keep the fund out of Grain Ledger entirely.

Skipping Funds (Do Not Record)

If you have funds in OnlineGiving.org that should not be recorded in Grain Ledger—such as internal test funds or pass-through accounts—choose “Do not Record Fund into Grain Ledger” in the Grain Ledger Fund dropdown. Gifts to that fund will be skipped cleanly rather than generating errors.

Cover-the-Fee Fund

When a donor covers the processing fee, the fee amount can be recorded as a separate contribution in Grain Ledger. To enable this:

  1. Navigate to Settings > Giving Settings.
  2. Find “Grain Ledger Cover the Fee Fund ID”.
  3. Enter the Grain Ledger fund ID where you want fee contributions posted (you can find this ID in your Grain Ledger fund settings).
  4. Click “Save”.

When configured, a $250 gift with a $7.50 covered fee records as two contributions: $250 to the designated giving fund and $7.50 to the fee fund. This keeps gift income and fee offsets separable in your accounting. When this setting is blank, the covered fee stays on the original gift contribution.


Donor and Household Matching

How the Matching Algorithm Works

Before creating a new donor record in Grain Ledger, the integration searches for an existing match using a four-step waterfall:

  1. External ID: Checks if the donor was previously created by OnlineGiving (highest confidence).
  2. Email Search: Searches Grain Ledger by email address. An email match is accepted immediately.
  3. Name Search: Searches by first and last name. A name match is accepted if it’s the only result or the first name matches exactly.
  4. Phone Search: Searches by phone number, but only accepts an email match from the results (shared phones are too common for name-only matching).

This approach eliminates duplicates without manual intervention while being conservative enough to avoid false matches.

Household Sync

When a donor is matched or created, the integration also syncs their household to Grain Ledger. Household members are positioned correctly:

  • Primary: The head of household
  • Spouse: The spouse
  • Child: Children in the household
  • Other: Other household members

This ensures household-level giving statements in Grain Ledger are accurate.

Viewing a Donor’s Grain Ledger ID

  1. Navigate to People > Users.
  2. Click on the donor’s name to open their profile.
  3. The Grain Ledger ID field shows their linked Grain donor record.

Manual Donor Linking

In rare cases where automatic matching doesn’t find the right person, you can manually enter a Grain Ledger Donor ID on the user’s profile. This is useful for edge cases like donors with different names across systems. The integration also supports manual donor linking in batch entry and check scanning.


Contribution Recording

How Recording Works

Every approved donation is queued for recording in Grain Ledger. The process is fully automatic:

  1. A gift is approved in OnlineGiving.org (card, ACH, check, crypto, DAF, QCD).
  2. The gift enters the recording queue.
  3. The system matches the donor (or creates a new one).
  4. The fund mapping is applied.
  5. An individual contribution is created in Grain Ledger with all details: donor, fund, amount, fee, payment method, and date.

If a fund is mapped to “N/A,” the gift is skipped. If the recording fails due to a network issue, the system retries automatically.

Cover-the-Fee Split

When a donor covers the processing fee and you’ve configured the Cover the Fee Fund ID (see Fund Mapping), two contributions are created:

  • The gift amount → the donor’s designated fund
  • The fee amount → the configured fee fund

Both contributions are linked to the same transaction, and both are included in the giving batch and settlement.

DAF and QCD Classification

Gifts from a donor-advised fund (DAF) or a qualified charitable distribution (QCD) from an IRA are automatically classified with the correct source type in Grain Ledger:

  • Direct gifts → classified as DIRECT (tax-deductible to the donor)
  • DAF gifts → classified as DAF (not tax-deductible to the donor—already deducted when the fund was created)
  • QCD from IRA → classified as QCD_IRA (not tax-deductible—it’s an IRA distribution)

This classification happens automatically based on the gift source configured in OnlineGiving.org, so your year-end giving statements are accurate without anyone remembering to flag individual gifts.

Viewing the Grain Ledger Contribution ID

  1. Navigate to Giving > Donations.
  2. Find the transaction and click to view details.
  3. The Grain Ledger status and contribution ID are displayed.

How to Retry a Failed Recording

If a recording fails after all automatic retries, you can retry it manually:

  1. Navigate to Giving > Donations.
  2. Find the transaction with a failed Grain Ledger status.
  3. Click “Retry” to re-queue the recording.

Every record carries a unique identifier, so retrying is always safe—it will never create a duplicate contribution in Grain Ledger.


Giving Batches and Bank Settlements

How Batches Work

When a giving batch is closed in OnlineGiving.org, all the contributions in that batch are grouped into a Grain Ledger giving batch. The batch totals are derived from the contributions themselves—they are never hand-keyed—so the batch total always matches the sum of the gifts inside it.

How Settlements Work

After a batch is created, OnlineGiving also files a bank deposit settlement in Grain Ledger (unless settlements are disabled). The settlement contains:

  • Giving total: The total of all contributions in the batch
  • Payment count: The number of distinct charges in the batch
  • Estimated arrival date: Calculated from the batch close date plus the gateway’s typical settlement window

Your treasurer opens Grain Ledger and finds the deposit expectation already waiting—they know how much to expect and when.

Disabling Settlements

If your bank’s funding pattern doesn’t align with how OnlineGiving groups deposits (for example, if your bank combines multiple days into one deposit), you can disable automatic settlement creation:

  1. Navigate to Settings > Giving Settings.
  2. Set “Disable Grain Ledger Settlements” to 1.
  3. Click “Save”.

Giving batches will still be created in Grain Ledger, but you’ll manage deposit entries yourself.

Deposit Basis (NET vs GROSS)

The Grain Ledger Deposit Basis setting tells the settlement how your payment processor handles fees:

  • NET (default): The processor deposits the amount after deducting fees. Most gateways work this way.
  • GROSS: The processor deposits the full amount and debits fees in a separate transaction.

If you’re not sure which to use, leave it at NET.


Refund Handling

Automatic Refund Sync

When a gift is refunded in OnlineGiving.org, the correction flows to Grain Ledger automatically. The contribution is marked as refunded with the refund date and a note. If the gift had a cover-the-fee split, both the gift contribution and the fee contribution are corrected.

Closed-Period Alerts

If a refunded contribution is in an accounting period that your treasurer has already closed in Grain Ledger, the system cannot modify it. Instead of silently failing, OnlineGiving creates an alert in your Message Inbox with:

  • The Grain Ledger contribution ID
  • The OnlineGiving transaction number
  • The refund amount
  • Grain Ledger’s error message
  • Instructions to correct it manually in Grain Ledger

This ensures no refund is ever lost or silently ignored.


Settings Reference

All Grain Ledger settings are found in Settings > Giving Settings:

  • Connect / Disconnect: One-click secure connection to Grain Ledger
  • Cover the Fee Fund ID: Grain Ledger fund for covered processing fees (optional)
  • Deposit Basis: NET or GROSS (default: NET)
  • Disable Settlements: Set to 1 to turn off automatic bank deposit settlements (optional)

Running Alongside Your ChMS

Grain Ledger is an accounting platform, not a church management system. The integration uses dedicated fields (grain_id) on donors, funds, and transactions that do not conflict with any ChMS integration. You can run Grain Ledger simultaneously with:

  • Planning Center
  • Ministry Platform
  • Rock RMS
  • Breeze ChMS
  • QuickBooks
  • Any other supported integration

The same gift records to your ChMS for pastoral care and people management, and to Grain Ledger for fund accounting. Neither system knows about or interferes with the other.


Frequently Asked Questions

How do I connect Grain Ledger to OnlineGiving.org?

Go to Settings > Giving Settings and click “Connect to Grain Ledger.” You’ll be redirected to Grain Ledger to authorize. No API keys or passwords are needed—the entire process takes about 30 seconds.

Can I use Grain Ledger alongside Planning Center or Rock RMS?

Yes. Grain Ledger uses its own dedicated fields and does not conflict with any ChMS integration. The same donation records to both systems automatically.

How do I map my funds?

Edit each fund in Giving > Funds and pick the matching Grain Ledger fund from the dropdown. To skip a fund, choose “Do not Record.” If you see a text field instead of a dropdown, paste the fund ID from the Grain Ledger fund URL, or enter N/A to skip.

What if a donor doesn’t exist in Grain Ledger yet?

The integration creates a new donor record automatically, including their name, email, phone, and address. Households are also synced. Future gifts will match to the same donor record.

How does the cover-the-fee split work?

When configured, the covered fee posts as a separate contribution to a designated fund in Grain Ledger. For example, a $250 gift with a $7.50 covered fee creates two contributions: $250 to General Fund and $7.50 to the fee fund. This keeps gift income and fee offsets clean in your accounting.

What happens when I refund a gift?

The refund flows to Grain Ledger automatically. The contribution is marked as refunded. If the contribution is in a closed accounting period, you’ll see an alert in your Message Inbox with instructions to correct it manually.

What are bank deposit settlements?

When a giving batch closes, OnlineGiving files a settlement in Grain Ledger with the giving total, payment count, and estimated arrival date. This tells your treasurer a deposit is coming, how much to expect, and approximately when. You can disable settlements if your bank’s funding pattern doesn’t align.

How are DAF and QCD gifts handled?

Gifts from a donor-advised fund are classified as DAF, and qualified charitable distributions from IRAs are classified as QCD. This ensures year-end giving statements correctly show which gifts are and aren’t tax-deductible to the donor.

Is it safe to retry a failed recording?

Yes. Every record carries a unique identifier that prevents duplicates. Retrying will either complete the original recording or confirm it already succeeded—it will never create a duplicate contribution.

How do I disconnect from Grain Ledger?

Go to Settings > Giving Settings and click “Disconnect Grain Ledger.” All stored tokens and links are cleared immediately. Contributions already recorded in Grain Ledger are not affected.

Who do I contact for help with the Grain Ledger integration?

Contact us at support@onlinegiving.org. Our team monitors all integration communications and can help with setup, fund mapping, or troubleshooting.

 

Have questions about this article?

Our Support GPT knows this article and the entire knowledge base.

Knowledge Base