Automated Reconciliation creates a cash deposit transaction in Enterprise Cash Book for each Momentus Payments batch. Credit card transactions, ACH payments, and refunds are automatically added to the deposit and associated with their corresponding Enterprise order. You are then able to review the deposit and post it to generate the associated journal entries.
By default, the sync tasks run overnight, but you are able to update the time as needed for your organization.
To configure automated reconciliation you will:
- Create the standard configurations.
- Add a bank account to the payment configuration.
- Create the scheduled tasks for the sync.
- Add a GL Account to the Transaction Type.
Create the Standard Configurations
When customers are set up with Momentus Payments, Auto-Create Standard Configurations is run. This creates all necessary transaction types. Re-run this to confirm that this is complete and the transaction types needed for automated reconciliation are created:
- In the Main Menu, search for and select Momentus Payment Gateways. The Momentus Payments modal opens.
- Select the appropriate gateway.
- Click Tools > Auto-Create Standard Configurations. The process runs.
Add a Bank Account
- In the Main Menu, search for and select Momentus Payment Gateways. The Momentus Payments modal opens.
- Select the appropriate gateway and open the reading pane, or right click and select Edit > Edit Momentus Payments Configuration.
- In the Bank Account field, select a bank account.
- Click Save.
Create the Scheduled Tasks
You are now ready to create the tasks which will execute the sync each day.
- In the Main Menu, search for and select Momentus Payment Gateways. The Momentus Payments modal opens.
- Schedule the Payout and ACH sync:
- Click Tools > Schedule Payout/ACH Sync.
If you get a message that the task is already created, go to the Scheduled Tasks page and review the task. To find it more easily, filter by the type Payout/ACH Sync.
- Add the necessary information:
- Description: Name the task. We recommend "Payout/ACH Sync".
- Interval: How often the task should run. We recommend daily.
- Task Start Date: Date the sync should begin.
- Time: Time each day the sync should run. We recommend a time that is outside of business hours, preferably overnight.
- Click Save.
- Click Tools > Schedule Payout/ACH Sync.
- Schedule the refund sync:
- Click Tools > Schedule Refund Sync.
If you get a message that the task is already created, go to the Scheduled Tasks page and review the task. To find them it easily, filter by the type Refund Sync.
- Add the necessary information:
- Description: Name the task. We recommend "Payout/ACH Sync".
- Interval: How often the task should run. We recommend daily.
- Task Start Date: Date the sync should begin.
- Time: Time each day the sync should run. We recommend a time that is outside of business hours, preferably overnight.
- Click Save.
- Click Tools > Schedule Refund Sync.
Add a GL Account to the Transaction Type
A Payout-Deposit transaction type was created during the Auto-Create Standard Configurations process. Review the GL Distributions on the transaction type and add a GL account as needed:
- Navigate to the Cash Book Transaction Types page and select the Payout - Deposit type.
- Right-click and select Edit > Edit Cash Book Transaction Type. The Edit Cash Book Transaction Type page opens.
- In the GL Distribution section, click Insert Row. A row is added in edit mode.
- Add the necessary information. For more information about GL Distributions, see GL Distribution Overview.
- Click Save & Close.