The exporting feature in Claimable lets you to export your claims data to a CSV or XLSX file based on your Filters or Labels.

Exporting Claims from Filters or Labels 

When exporting your claims, the file generated will respect the columns shown for the currently selected filter or label. To initiate an export, choose the filter or label you want to extract and click the Export button.

Before the export begins, you get the choice of downloading a CSV or an XLSX file. Generally speaking, CSV works well if you intend to share the file or integrate with another system. Whereas XLSX files can be opened by all major office spreadsheet applications, such as Microsoft Excel and Google Sheets.

Simply click the file type you want your export to be in and click "Export".

Export Options

When exporting claims you can use the following options to further customise the exported file.

Include All Columns?

When initiating the export, you get the option to override the default behaviour of exporting only the columns shown for the chosen filter or label, by choosing to export all available columns. To export all columns, simply tick the 'Include all columns?' box.

This might be useful if you need to create reports that require columns that are not shown for any of your filters or labels, or for data backup purposes.

Include damages tab? (XLSX format only)

This option will add a separate "Damages" tab to the XLSX export, which lists all damages for every claim on the export.

Because a claim can have multiple damages, each damage will have a separate line, with identifying claim columns repeated so you know which claim the damage belongs to, such as "Claim ID", "Claim Ref." and "Claim Title".

The damage-specific columns included are:

  • Damage ID - a unique reference that identifies this particular damage.
  • Damage Type - the "Damage Type" chosen for this damage.
  • Description - any "Description" entered for this damage.
  • Contact - if this damage is linked to a specific claim contact, their name will show here.

Include payments tab? (XLSX format only)

Similar to damages (above), this option will add a separate "Payments" tab to the XLSX export, which lists all payments for every claim on the export.

Because a claim can have multiple payments, each payment will have a separate line, with identifying claim columns repeated so you know which claim the payment belongs to, such as "Claim ID", "Claim Ref." and "Claim Title".

The payment-specific columns included are:

  • Payment ID - a unique reference that identifies this particular payment.
  • Payment Date - the payment date entered for this payment.
  • Reference - a unique reference that can be used when making payments (for example if you upload to your bank's batch payment system). The reference is in the format of {Claim ID}-{Payment ID}-{Payment Index on Claim} (e.g. "3735-1341-2"), allowing you to identify both the claim (e.g. ID 3735) and payment (e.g. ID 1341). The last segment (e.g. 2) indicates the index number of the payment within the claim (e.g. the 2nd payment), which is helpful when multiple payments exist per claim.
  • Description - the "Description" entered for this payment. 
  • Payment Method - the "Payment Method" chosen for this payment. 
  • Payment Type - the "Payment Type" chosen for this payment. 
  • Beneficiary Account Name - the "Account Holder's Name" as per the Payment Details section on the claimant's contact record.
  • Beneficiary Bank Name - the "Bank Name" as per the Payment Details section on the claimant's contact record.
  • Beneficiary Sort Code - the "Sort Code" (or "ABA / Routing No" for US) as per the Payment Details section on the claimant's contact record.
  • Beneficiary Account Number - the "Account Number" as per the Payment Details section on the claimant's contact record.
  • Beneficiary SWIFT/BIC - the "SWIFT/BIC" as per the Payment Details section on the claimant's contact record.
  • Beneficiary IBAN - the "IBAN" as per the Payment Details section on the claimant's contact record.
  • Net Amount - The "Net Amount" entered for this payment.
  • VAT - The "VAT" entered for this payment.
  • Total  - The Total (Net Amount + VAT) of the payment.

Searches

If you've searched for something before initiating an export, the exported file will only include the search results.

In order to export all results, simply click the search reset button to remove any search terms and try initiating the export again. 

In the example below, the exported XLSX file will include 9 claims matching the search term "jones" and will include all available claims columns, with an additional tab for damages. 

Need help?

Just click the support chat bubble in the bottom right corner and we will happy to assist you.

Did this answer your question?