The Filebox Link feature allows you to automate the flow of supporting files into the Reconciliation Module. Once a Filebox is linked to an entity, any new file versions uploaded or calculated in that Filebox will automatically sync into Month-End Close, with amounts detected and assigned to the correct accounts.

This article walks through how to create a Filebox Link, how synced files behave, and how to handle undetected items and locked dates.

Creating a Filebox Link

Follow these steps to connect a Filebox to a specific entity in the Reconciliation Module:

1. Navigate to Month-End Close → Settings.

2. Under Filebox Links, select the entity you want to configure.

3. Click Create Filebox Link to begin setting up the connection.

4. A list of Fileboxes that use monthly tag will appear.

   • Browse and select the Filebox you want to connect.

5. Choose the first month to sync.

   • Only months with available versions in the Filebox will appear- versions from prior months will not be synced into the reconciliation module 

6. Click Save.

The system will display a message confirming that the Filebox is syncing.

Viewing Synced Files in the Reconciliation Module

Once synced:

• Go to Reconciliation → Supporting Items.

• You will now see the working paper automatically added to the Supporting Items list.

• Accounts and amounts are detected automatically using the #DR pattern inside the Excel file.

Handling Files That Are Not Automatically Detected

If a file does not include the required #DR-XXXX pattern, the system cannot map the amounts.

When this happens:

• An Unlinked Files badge appears in the reconciliation screen.

• This indicates that files were synced, but their accounts and amounts were not detected.

To fix this:

1. Click the Unlinked Files badge.

2. Select Edit.

3. Choose the relevant account (e.g., Credit Cards).

4. Enter the correct amount.

5. Click Update.

The file is now mapped to the right account for that month.

Automatic Sync for New Months

As soon as the new monthly version is created in a Filebox by manual submit/integration sync/auto-calculate:

• The September file (in this example) appears in the Reconciliation Module.

• Accounts and amounts are already mapped.

• The difference is zero, and you can sign off without any manual updates.

For more information about Excel modeling and how to automate your processes using datarails add-in, you can refrer to the following article here

Locking Filebox Data

If you want to prevent new versions from syncing into Reconciliation:

1. Open the supporting items management.

2. Select the relevant file.

3. Click Lock.

When a month is locked:

• No new versions will be created for that date tag.

• No new files will sync into the Reconciliation Module.

This is useful when the reconciliation is finalized and should not change.

Summary

Using Filebox Links, you can:

• Automate the flow of supporting items into the Reconciliation Module

• Ensure amounts are detected correctly using the #DR-XXXX pattern

• Reduce manual uploads and mapping

• Generate new versions each month through Filebox calculations

• Identify and correct undetected files quickly

• Lock periods to prevent unintended changes

This automation significantly streamlines the reconciliation process, ensuring accuracy and eliminating repetitive manual work.

Updated December 02, 2025 17:04