Standard Statement Routines & Processes
An overview of the Statement Maintenance routine and Statement Maintenance process that impact standard statements.
It's important for statements to be correct when you generate them — be that quarterly, annually, or randomly. A nightly routine and an on-the-fly process ensure your donor statements are accurate no matter when you generate them.
Routine
Current, unarchived statements are managed nightly by the Statement Maintenance routine. This nightly routine does the following:
- It associates donations with the correct statement once batched. The Statement field on the Donations page makes this possible.
- It populates the statement description on donation distributions based on the program, event, or pledge:
- The Statement Description cannot be blank and defaults to the program.
- If the Target Event field is populated, then that value is used instead of the Program.
- If the [Pledge Campaign]: Donor field is populated and the pledge donor is different from the donation donor, then that value is used instead of the program or target event.
- If the donation's Payment Type ID is set to 6 or Omit Amount On Statement is set to 1, then the Notes field is used on the donation, and the routine adds one of the following:
- The Pledge Campaign Nickname (if there is one)
- The Event Title (if there is one)
- The Program Statement Title (if there is one)
- It associates donors with the correct statement.
- It updates the salutation as needed. For example, if there is a new head of household, if a head of household is removed, if there are name changes to heads of household, or if there are changes to the accounting company's Formal Salutation field.
- It indicates the date and time the statement changed.
- It updates the statement file on the record.
- It creates a household, if the donating contact is not already in one.
The Statement Maintenance routine scrutinizes anything connected to an unarchived statement in case something in the database changed and made an item no longer relevant to that statement. For example, if someone is removed from a household, they will no longer be listed on the unarchived statement. There's a very long list of things that can impact whether and how items display on a statement:
- Archive appropriate statements.
- Remove donors who are no longer associated with the statement.
- Remove donations that are no longer associated with the statement, batch, current year, and so on.
- Remove mail contact, spouse contact, and mail name when appropriate.
- Update salutation.
- Remove the donation distributions statement description if changes have happened to the statement since the last review.
- Address multiple statements where neither is archived by deleting the second one.
- Delete multiple instances of a donor on one statement.
- Delete completely orphan statements, if the parameter is set to Yes.
- Clean-up.
Process
The Statement Maintenance routine runs nightly. But you can accomplish the same thing at any time by updating any (or all!) of these fields on the Accounting Company record:
- Statement Cutoff Date
- Formal Salutation
- Standard Statement
So when should you execute the process instead of waiting for the nightly routine? While you probably won't use the process often, you should it when:
- The statement cutoff date is changed to an earlier date. In this case, all donations before that date are disassociated with the statement.
- The statement cutoff date is changed to a later date. New donations might be associated with the statement.
- The formal salutation is changed. The salutation on each statement would need to be refreshed to reflect this decision.
This default Statement Maintenance Required process is installed at deployment.