---
title: "Find the total outstanding balance of your gift cards/store credit vouchers"
description: "How to generate a report on gift cards, store credit vouchers, and deposits, and find out how much you owe customers."
url: https://helpcenter.c1st.com/en/articles/5145527-find-the-total-outstanding-balance-of-your-gift-cardsstore-credit-vouchers
collection: "Giftcard & Vouchers"
updated: 2026-11-19
language: en
alternates: [da, sv, nb]
---

# Find the total outstanding balance of your gift cards/store credit vouchers

How to generate a report on gift cards, store credit vouchers, and deposits, and find out how much you owe customers.

The gift card export gives you an overview of the gift cards, store credit vouchers, and deposits issued by your store, and how much is still outstanding to customers. It’s useful for you or your accountant/bookkeeper.

The export selects gift cards based on the date they were created, not when they were used. It includes all types: gift cards, deposits, and store credit vouchers.

## How to do it

1.  Go to **Statistics**.
    
2.  Click **Export** and select **Gift cards**.
    
3.  Optionally select **Type** and **Status** (see below).
    
4.  Select the period using **Created from** and **Created through**.
    
5.  Select a file format, e.g. **XLSX (Excel)**, and click **Download**.
    
6.  Open the file in Excel (Windows) or Numbers (Mac).
    

![The Download export dialog shows Type, Status, Created from, Created until, and Format fields with Close and Download buttons. Visible: Download export, Type, All, Status, Created from, Created until.](https://staticfiles.gleap.io/ghelparticle/A65ApVi8u4oAd7zRAI0nRKY9ZdEifFjjAT4RbNisPVP662CQBx2LiS3BySLx60WSCRi0g8euD9W.png)

## Choose period, type and status

**Period:** By default, both dates are set to today. If you want all gift cards, leave **Created from** blank. This will include all gift cards, including those created before the store was set up in the system, such as imported gift cards. If **Created through** is left blank, gift cards up to and including the end of the year will be included.

**Type:** Select **All**, **Gift cards**, **Deposit** or **Credit voucher**.

**Status:** Select **All**, **With balance** or **Expired or used up**. If you only want to see outstanding items, select **With balance**.

Please note that you will be notified that there is no data if no gift cards match your selections.

## How to read the file

Each row is one gift card, voucher, or deposit. The most important columns are:

-   **amount** is the amount originally issued.
    
-   **amountspent** is the amount spent.
    
-   **balance** is the remaining amount.
    
-   **createddate** and **expirationdate** are the creation and expiration dates.
    
-   status is **Active** or **Inactive** (expired or used up).
    
-   latesttransactiondate is the date of the most recent use or change.
    

The file also contains the gift card number, type, customer's name and phone number, and the payment number for the sale in which the gift card was issued.

**NOTE:** At the bottom of the file, there is a total sum of **balance**, which is the total outstanding amount.

```javascript
Keywords: Deposit - Prepayment - Partial payment - Credit
```
