Once the report is exported open it in something like Excel and sum up each of the columns to see the total values from that period.

Columns that will align with Link My Books data are:

Sold value - shows the total amount of gift cards that have been sold.

Redeemed value - shows the total amount of gift cards that have been redeemed.

Refunded value - shows the total amount of gift cards that have been refunded.

If you sum up the total of all 3 of these columns and compare that figure to the figure you have showing in the data sent over from Link My Books to your bookkeeping system they should match.

To download the Link My Books settlement entries in bulk to a CSV file follow these steps:

From the Settlement Dashboard, click the Download icon at the top right:

Select a date range you wish to download and click Download to CSV:

The file may take some time to generate depending on the size of your account and the selected date range.

Apply a filter to the description column for Shopify Gift Card and that will reveal all the sales, refunds and redemptions of gift cards.

Sum up the amount column and then compare that number to the figure you obtained from Shopify.

If you're using our default account mappings then the sales, refunds and use of gift cards will be accounted for under the nominal accounts:

LMB30: Shopify Sales

LMB31: Shopify Refunds

To make it easier for you to reconcile your gift card figures directly in your bookkeeping system we'd suggest setting a custom account mapping for gift cards like this:

This way the sales, refunds and use of gift cards will be accounted for under this one account and they will be separated from your general sales.

If you've already sent data from Link My Books to your bookkeeping system and you want to retrospectively make this change then you can do so by first updating your mappings via the Accounts & Taxes Mapping page and then afterwards using our rollback feature to roll back settlements and then re-send them.