Spend: Batch

To incorporate a platform's spend in Rockerbox, first check in Rockerbox if the platform has an available Integration. If so, follow the instructions in the platform.

If Rockerbox does not have a pre-built integration with a platform to import spend, then you can request Rockerbox work with the partner to ingest regularly scheduled files. The partner will need to meet Rockerbox requirements for file delivery and contents, described below.

Steps to bring in spend for vendors without a pre-existing integration

1. Ask the partner for a sample spend report and share this with your Rockerbox team

• After receiving the sample file, Rockerbox will confirm the file format meets our standard report format requirements
  
  

2. Determine on what cadence the partner can send spend to Rockerbox and which delivery method is preferred (Email, SFTP, or S3)

• Rockerbox does not support downloading spend on behalf of clients. This must be managed entirely by the partner or by your team
• After you determine the preferred delivery method Rockerbox will provide endpoint details to you and your partner
  
  

3. Once Rockerbox has confirmed the file format meets our requirements, the partner will be responsible for sending the spend file on the agreed-upon cadence (daily or once per week)

4. After the first files have been received to the endpoint, Rockerbox will complete the needed set up on our end to configure the data processing

5. Once the setup is complete, the files will automatically process once received

• If files are sent outside of the agreed-upon cadence, please contact your Rockerbox team to ensure the files processed as expected
  
  

Delivery Timing

Schedule delivery of the Batch Spend report between 4-8am EST (9am-1pm UTC). This is to make sure the data is updated in a timely fashion.

Note: if you also have Report Exports scheduled, then you will need to provide a 2-hour buffer between delivery of the Batch Spend file and the scheduled report to ensure the Spend file has time to process before the reports are scheduled to run.

For example, if you have a scheduled report for 9am EST, then you need to ensure the Batch Spend report is delivered by 7am EST.

Spend Reconciliation

❗️

Spend adjustments are not supported

Rockerbox cannot make changes to Batch Spend once ingested, or accept negative spend values. If you are working with a partner where you reconcile spend, read below carefully.

Once you or your partner sends a Batch Spend file to Rockerbox, you cannot make adjustments to that spend, or retroactively subtract spend. Therefore, if you have a reconciliation process with your partner—common with affiliates—then you need to decide what type of spend to send to Rockerbox:

1. Send pre-reconciled data only
2. Send post-reconciled data only

The advantage of (1) is that the data will appear in Rockerbox sooner. However, our recorded numbers will be higher as compared to what you eventually pay your partner.

On the other hand, sending to Rockerbox post-reconciled spend—or option (2)—will be more accurate as compared to your payments, but will be delayed by your reconciliation window.

If you need help deciding whether you should send pre- or post-reconciled spend, contact your Rockerbox account manager.

Report Columns

📘

File Requirements

Ensure you meet the Report Delivery Requirements.

📘

Non-USD Currency

For spend reports that include non-USD currency, you need to indicate it in one of two different methods:

1. The spend report will always be delivered in exactly one currency (ex: GBP, EUR). In that case, you need to communicate that to your Rockerbox rep so that they set up the report accordingly

2. Include a Currency column in the report (see the table above) in ISO-4217 format.