Questions? We have answers.

Data checklist: General ledger not-for-profit with fund

Article author
Tasha Kociszewski
  • Updated

Summary

Learn about the data necessary for a not-for-profit with fund general ledger analysis in MindBridge.


General ledger

Required columns

Account ID: Contains codes used to identify your client’s accounts. This column helps MindBridge understand your client's account types. This column can be filtered with the filter builder.

Example: 14028

This column affects the following control points:

  • Cash Expenditure
  • Cash to Bad Debt Conversion
  • Complex Structure
  • Duplicate
  • Expert Score
  • Flow Analysis
  • Fund Expense Flurry
  • Outlier Anomaly
  • Rare Flow
  • Recurring Unusual Amount by User
  • Reporting Adjustment
  • Reversal
  • Reversed
  • Split Expense (Single Transaction)
  • Split Expense (Multiple Transactions)
  • Unusual Amount

Effective Date: Contains the date at which the transaction occurred. This is different from the “entered date” column, which records the date that the entry was entered in the general ledger. This column can be filtered with the filter builder.

Example: 1/1/2014

This column affects the following control points:

  • Cash to Bad Debt Conversion
  • End of Period
  • End of Year
  • Flow Analysis
  • Fund Expense Flurry
  • Outlier Anomaly
  • Recurring Unusual Amount by User
  • Reporting Adjustment
  • Start of Period
  • Start of Year
  • Weekend Post

Credit: Contains the amount of money that was credited for the line item in the transaction. This column can be filtered with the filter builder.

Example: 14472

This column affects the following control points:

  • 2 Digit Benford
  • Cash Expenditures
  • Cash to Bad Debt Conversion
  • Duplicate
  • Expert Score
  • Flow Analysis
  • High Monetary Value
  • Last 3 Digits
  • Material Value
  • Outlier Anomaly
  • Reporting Adjustment
  • Reversal
  • Reversed
  • Unbalanced Debits and Credits
  • Unusual Amount
  • Zero Entry

Debit: Contains the amount of money that was debited for the line item in the transaction. This column can be filtered with the filter builder.

Example: 14472

This column affects the following control points:

  • 2 Digit Benford
  • Cash to Bad Debt Conversion
  • Duplicate
  • Expert Score
  • Flow Analysis
  • High Monetary Value
  • Last 3 Digits
  • Material Value
  • Outlier Anomaly
  • Reporting Adjustment
  • Reversal
  • Reversed
  • Unbalanced Debits and Credits
  • Unusual Amount
  • Zero Entry

Optional columns

Amount: Contains the line item’s value. This column is found in general ledgers that don't use double-entry accounting (split debit/credit columns). This column can be filtered with the filter builder.

Example: 19834.22

This column affects the following control points:

  • 2 Digit Benford
  • Cash Expenditures
  • Cash to Bad Debt Conversion
  • Duplicate
  • Expert Score
  • Flow Analysis
  • High Monetary Value
  • Last 3 Digits
  • Material Value
  • Outlier Anomaly
  • Reporting Adjustment
  • Reversal
  • Reversed
  • Unbalanced Debits and Credits
  • Unusual Amount
  • Zero Entry

Transaction ID: Contains the transaction’s ID code. You can also generate your own transaction IDs later. This column can’t be filtered with the filter builder.

Example: 6524

This column affects the following control points:

  • Complex Structure
  • Duplicate
  • Reporting Adjustment
  • Reversal
  • Reversed
  • Sequence Gap
  • Unbalanced Debits and Credits

Memo: Contains the line item’s memo content. This is usually descriptive content providing context surrounding a transaction. This content can vary from verbal explanations to company codes. This column can’t be filtered with the filter builder.

Example: This was paid on Dec 7 from Account 1.2875. It was a manual entry.

This column affects the following control points:

  • Complex Instrument
  • Empty Text Field
  • Suspicious Keywords

Type: Contains a code denoting what type of transaction the line item falls under. This column can be filtered with the filter builder.

Example: CREDIT_PAYMENT

This column affects the following control points:

  • Manual Entry

User ID: Contains the name (or identifying code) of the user associated with the line item. This column can be filtered with the filter builder.

Example: Xavier McMannon

Entered Date: Contains the date at which the entry was added to the ledger. This is different from the “effective date,” which records the date that the transaction occurred. This column can be filtered with the filter builder.

Example: 1/6/2014

This column affects the following control points:

  • Weekend Post
  • Reversed
  • Reversal

Source: Refers to the source ledger/document that the entries came from. For example, a company may use a payroll system that generates and posts transactions to the GL. This field usually identifies the source via a code. The Manual Entry control point uses this field to identify entries that were identified as being entered manually.

Example: GL, PR

This column affects the following control points:

  • Manual Entry

MAC Code: Contains the line item’s MindBridge MAC code. This column can be filtered with the filter builder. To learn more about MAC codes, visit our article How MindBridge Classifies Accounts Using MAC Codes.

Example: 14001

This column affects the following control points:

  • Cash Expenditure
  • Cash to Bad Debt Conversion
  • Expert Score
  • Flow Analysis
  • Outlier Anomaly
  • Rare Flow
  • Recurring Unusual Amount by User
  • Split Expense (Single Transaction)
  • Split Expense (Multiple Transactions)
  • Unusual Amount
  • Fund Expense Flurry

Fund ID: Contains an identifier for the fund associated with each line item. This column can be filtered with the filter builder.

Example: 0003

This column affects the following control points:

  • Interfund Transfer
  • Split Expense (Single Transaction)
  • Split Expense (Multiple Transactions)
  • Fund Expense Flurry
  • Fund Description: Contains the name or description for the fund associated with each line item. This column can be filtered with the filter builder.

Example: Kids Rock! Summer School Programs


Opening balance

Required columns

Account ID: Contains codes used to identify your client’s accounts.

Example: 14028

Balance: Contains the balance for each of your client’s accounts as at the end of the period under audit.

Example: $18152.16

 

Optional columns

Account Description: Contains the names or descriptions of your client’s accounts.

Example: Legal fees

MAC Code: Contains the line item’s MindBridge MAC code. To learn more about MAC codes, visit our article How MindBridge Classifies Accounts Using MAC Codes.

Example: 14001

Fund ID: Contains an identifier for the fund associated with each line item. This column can be filtered with the filter builder.

Example: 0003

Fund Description: Contains the name or description for the fund associated with each line item. This column can be filtered with the filter builder.

Example: Kids Rock! Summer School Programs


Closing balance

Required columns

Account ID: Contains codes used to identify your client’s accounts.

Example: 14028

Balance: Contains the balance for each of your client’s accounts as at the end of the period under audit.

Example: $18152.16

 

Optional columns

Account Description: Contains the names or descriptions of your client’s accounts.

Example: Legal fees

MAC Code: Contains the line item’s MindBridge MAC code. To learn more about MAC codes, visit our article How MindBridge Classifies Accounts Using MAC Codes.

Example: 14001

Fund ID: Contains an identifier for the fund associated with each line item. This column can be filtered with the filter builder.

Example: 0003

Fund Description: Contains the name or description for the fund associated with each line item. This column can be filtered with the filter builder.

Example: Kids Rock! Summer School Programs


Chart of accounts

Required columns

Account ID: Contains codes used to identify your client’s accounts. This column helps MindBridge understand your client's account types.

Example: 14028

Account Description: Contains the names or descriptions of your client’s accounts.

Example: Legal fees

Fund ID: Contains an identifier for the fund associated with each line item. This column can be filtered with the filter builder.

Example: 0003

 

Optional columns

MAC Code: Contains the line item’s MindBridge MAC code. To learn more about MAC codes, visit our article How MindBridge Classifies Accounts Using MAC Codes.

Example: 14001

Fund Description: Contains the name or description for the fund associated with each line item. This column can be filtered with the filter builder.

Example: Kids Rock! Summer School Programs

 


Anything else on your mind?
Log in to MindBridge to chat with us, submit a request, or reach out to your assigned Customer Success Manager.


Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.