> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://docs.clientexec.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How Can I Change The Numbering Of My Invoices?

By default, when you install Clientexec, your invoice numbering will start at 1000. If you want to change this number you have a 
couple of options.

### Option 1:

If this is a fresh install or you currently have 0 invoices, you can go to **Settings** > **Billing** > **General** then for the input  **Invoice Start Number** you can enter the number you want to use.

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/screenshot-2023-03-21-at-13-44_giqxy4.png)

### Option 2.

If you already have existing invoices then option 1 will not work for you. What you can do is adjust this setting with an SQL query. To do this go to **Settings** > **Utilities** > **SQL Tool** and using the following query:

```html
ALTER TABLE invoice AUTO_INCREMENT = newStartingNumber
```

Change the **newStartingNumber** to the number you want to use. 

|| IMPORTANT: This number must be HIGHER then your current highest invoice number. So if your last invoice number was 1020 for example then you will need to use a number higher then that like so:

```html
ALTER TABLE invoice AUTO_INCREMENT = 5000
```

Using that query, your next invoice generated would be Invoice number 5000.

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/screenshot-2023-03-21-at-13-48_osva0r.png)