Open topic with navigation

You are here: Online Payment Processing > Reconciling E-Check Payments

Reconciling E-Check Payments

Fellowship One sends transactions to ProfitStars seven days a week. ProfitStars processes on business days only. ProfitStars closes the daily batch around 7:00 PM CST. Any transactions submitted after this timeframe will automatically roll over to the next day's batch. Your deposit is available the following business day. For bank holidays, the transactions will batch on the following business day at 7:00 PM Central.

ProfitStars batches and deposits on this 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

To reconcile your daily batch:

Please use the Core Giving Records Report G1050E (vX.X) with the following required parameters:

  1. Based on this Date= Received Date
  2. Ocurring within this Date Range=Custom Date Range
  3. Ocurred on or After= the day before the date you need (i.e. 08-09-2011)
  4. Ocurred on or Before=the day you want to see (i.e. 08-10-2011)
  5. Occurring on or After this Time=ProfitStars Batch Cycle Start
  6. Occurring on or Before this Time=ProfitStars Batch Cycle End
  7. Belonging to these Batches = No Value

We recommend that you choose the following additional filters beginning with the section titled "Configured Displayed Output":

  1. Page/Sheet Break On=No Page Break

  2. SubGroup with Subtotal On=Fund

  3. Giving Fields to Display=ACH, Check, Cash or Credit Card

  4. Contributor Fields to Display:Contributor Name

  5. Primary Address Fields to Display=Full Address

  6. Metric Subtotals to Display=Select None

  7. Sort Records by=Fund, SubFund, Amount

Click Additional Filters

At a minimum, the balance of the report parameters require a selection. You can leave the default selections or make your own EXCEPT for the "Return based on Contibution Type". You should choose ACH. If you choose "Select All", the system will return all of the Contribution Types rather than just the ACH Contribution Type.

If you are not familiar with the ProfitStars reporting section, while logged into ProfitStars, you will click the Reports tab and then select Credits and Debits to your Merchant Settlement Account. Select your beginning date. The end date defaults to today. Then, click the Credits and Debits link below the date range. The view will show you line item detail for each deposit. You can click the View Details link to see a line item description of all transactions that make up the total deposit. You can compare the deposit line items from ProfitStars with the results of this report.

To reconcile multiple days fill out the report with the following parameters simply change the Custom Date range filter:

Tip! Save this report in your "My Reports" so that you can use it repeatedly. This way, you only have to change the date range. You have the ability to rename it so you can find it easily.