FellowshipOne sends ACH transactions to ProfitStars. ProfitStars processes on business days only & closes the daily batch around 7:00 PM CST. Any transactions submitted after this time automatically roll over to the next day’s batch. The deposit is available on the next business day. When there is a banking holiday, the transactions are batched the next business day at 7:00 PM CST.
ProfitStars batches & deposits on the following cycle:
- Mon after 7PM -Tue at 7PM Deposit Wed
- Tue after 7PM - Wed at 7PM Deposit Thurs
- Wed after 7PM - Thurs at 7PM Deposit Fri
- Thurs after 7PM to Fri at 7PM Deposit Mon
- Fri after 7PM to Mon at 7PM Deposit Tue
There are two methods for reconciling individual transactions to bank deposits. While the most recommended method is to use the G1050: Core Giving Record report, the ProfitStars portal can also display a line item detail for each deposit.
- Login to ProfitStars
- Click Reports tab
- Select Credits & Debits to your Merchant Settlement Account
- Select beginning & ending date
- Note: end date defaults to today
- Click Credits & Debits link below date range
This view shows a line item detail for each deposit. Click View Details to see a line item description of all transactions that make up a total deposit. For best results, compare the deposit line items from ProfitStars to the results of the G1050 report.
ACH Reconciliation
Use the G1050: Core Giving Record report.
Return Giving Records (who)
Based on this Date: Received Date
Occurring within this Date Range: Custom Date Range
Occurred on or After: Enter day BEFORE first day in the range
Occurred on or Before: Enter last day in range
Occurring on or After this Time: ProfitStars Batch Cycle Start
Occurring on or Before this Time: ProfitStars Batch Cycle End
Belonging to these Batches: Ignore This
Choose Fields & Configure Output (what)
Page Sheet Break On: Ignore This
SubGroup with Subtotal On: Ignore this
Gift Columns to Display: All Transactions by ID, ACH, Check, Cash or Bank Card, Fund, Originating Source, Received Date, Received Time
Contributor Columns to Display: Contributor Full Name (optional)
Sort Records By: Received Date & Time
Under Additional Filters, select the following filters:
Return Based on Contribution Type
Having these Contribution Types : ACH
Return Based on Origination
Created from this Source: Online Giving, Remote Deposit Capture, WebForm Registration (if using webforms)
Choose Excel for out put type
Click Run or Save report
Reconciling with Bank Deposits?
This report produces a spreadsheet with a list of transactions in the order in which they were received by FellowshipOne. Compare the deposits on the bank statement to the report output. Remember, the deposit date is 1-3 days after the date of the transaction, depending on whether or not it occurred on a weekend. Note the amount of the deposit then, beginning at the top of the spreadsheet, highlight the contributions in the Amount column until the sum at the bottom of the screen matches the amount deposited in the bank. Use the blank column to the right of the Amount column to indicate which transactions are included in a specific deposit.
Continue down the sheet, highlighting subsequent transactions to match the rest of the deposits from the bank statement.
Updated