> For the complete documentation index, see [llms.txt](https://kb.bevica.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.bevica.com/bevica-select/opening-balances-inventory/bevica_select_-_fixed_asset_opening_balances.md).

# Fixed Asset Opening Balances

Bevica Select has an Excel Template to import Fixed Asset opening balances, **B-FIXED ASSETS**. If it is not already in your company it is available to download at the end of this article.

### Before you start

* Understanding the Configuration Worksheet: [Configuration Worksheet](/bevica-select/bevica_select_training/bevica_select_-_excel_template_data_migration.md#configuration-worksheet).
* Understanding Excel templates: [Excel Template Data Migration](/bevica-select/bevica_select_training/bevica_select_-_excel_template_data_migration.md#excel-template-data-migration).

### Switch off G/L integration

Prior to entering or importing your fixed asset opening balances, you must ensure that the depreciation book you are going to use has the GL integration switched off. To do this, open the depreciation book record and ensure all fields in this section are toggled off.

![Depreciation Book card showing the G/L integration fields toggled off before importing fixed asset opening balances.](https://2760122862-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fx3XuahSies5HnodsWowA%2Fuploads%2Fgit-blob-4f87bf8daad5c19d789725860f3c3122ca6b47fb%2FuBvtL3oQuWRBmqDPbS9Ji7UkkotKxsmn3A.png?alt=media)

### Create a manual fixed asset journal

If you would prefer to create the opening fixed asset journal manually rather than importing a template, navigate to the Fixed Asset Journals and open the DEFAULT journal batch. Populate the columns listed below except for:

* Journal Template Name
* Journal Batch Name
* Line No.

### Template

The template is a pre-formatted spreadsheet with the fields you need to create your opening fixed asset transactions within Bevica.

You will need a list of the following opening balances values per fixed asset record:

* A journal line for the Acquisition Cost
* A journal line for the depreciation value to the end of the last fiscal year
* A journal line for the depreciation value YTD
* You can create a further line for the salvage value if applicable

The template has the following fields:

<table data-header-hidden="false" data-header-sticky><thead><tr><th width="159">Field ID / Field Name</th><th width="163">Related Table</th><th width="138">FieldType</th><th>Note</th></tr></thead><tbody><tr><td>1 <code>Journal Template Name</code></td><td>(5619) FA Journal Template</td><td>Code 10 (Mandatory)</td><td>Enter ASSETS</td></tr><tr><td>2 <code>Journal Batch Name</code></td><td>(5620) FA Journal Batch</td><td>Code 10 (Mandatory)</td><td>Enter ZZ-DM</td></tr><tr><td>3 <code>Line No.</code></td><td></td><td>Integer (Mandatory)</td><td>Must be a unique number per line. Line numbers normally start with 10000 and increment by 10000, for example 10000, 20000, 30000</td></tr><tr><td>4 <code>Depreciation Book Code</code></td><td>(5611) Depreciation Book</td><td>Code 10 (Mandatory)</td><td>Enter the Depreciation Book Code</td></tr><tr><td>5 <code>FA Posting Type</code></td><td></td><td>Option (Mandatory)</td><td>• Acquisition Cost<br>• Depreciation<br>• Salvage Value</td></tr><tr><td>6 <code>FA No.</code></td><td>(5600) Fixed Asset</td><td>Code 20 (Mandatory)</td><td>This is the Fixed Asset No.</td></tr><tr><td>8 <code>Posting Date</code></td><td></td><td>Date (Mandatory)</td><td></td></tr><tr><td>11 <code>Document No.</code></td><td></td><td>Code 20 (Mandatory)</td><td>Populate this with a relevant document number reference</td></tr><tr><td>12 <code>External Document No.</code></td><td></td><td>Code 35</td><td>Populate this if you have another reference to bring across</td></tr><tr><td>13 <code>Description</code></td><td></td><td>Text 100</td><td>Enter a relevant description</td></tr><tr><td>14 <code>Amount</code></td><td></td><td>Decimal (Mandatory)</td><td>This should be a credit value for depreciation and salvage value and a debit for acquisition cost.</td></tr></tbody></table>

### Upload the journal

Once the template has been applied, navigate to the Fixed Asset Journal **ZZ-DM** batch and check that the journal holds the same information as the data migration template used.

* Ensure all columns you have imported data into are visible (with the exception of Journal Template Name, Journal Batch Name and Line No.).
* Have all the lines been imported?
* Select a number of lines at random. Are they all correct and the values both correct?
* Export the journal lines to Excel and make sure the details look correct, including dates and values.
* From the Fixed Asset Journal page preview or print a **Test Report** (Actions, Posting, Test Report)
* Select **Process,** **Post** then **Preview Posting**. Check the entries that will be posted look correct.

### Post the journal

Before Posting any opening balances, it is a good idea to copy the company as a backup, so you have a point to return to if there are problems once the **Fixed Asset Journal** has been posted. See [Bevica Select - Creating new Bevica companies](/bevica-select/bevica-select-data-migration/bevica_select_-_creating_new_bevica_companies.md) for information on how to do this.

### Reconcile

Once Posted, the entries need to be reconciled with the values from your old system. The following should be checked:

* Balance on Fixed Accounts. Check that the figures on your old system and Bevica match.
* If your opening trial balance has been imported, check that the FA opening entries posted match the relevant GL Accounts. If your opening TB hasn't yet been imported, check the opening FA entries against your old system.

Another trusted user, rather than the person who created and posted the opening balance, should perform these checks. They should do this using their own data source from your previous system and not rely on the migration files you used in case there were errors on those.

### Switch on G/L integration

Once you have imported and reconciled your fixed asset opening balances, you must ensure that the depreciation book you used has the GL integration switched back on. To do this, open the Depreciation Book record and ensure all relevant fields in this section are toggled on.

![Depreciation Book card showing the G/L integration fields toggled back on after importing and reconciling opening balances.](https://2760122862-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fx3XuahSies5HnodsWowA%2Fuploads%2Fgit-blob-4db4e931cb15b74102529ed10fec3a05aaeff26d%2F3wl3QkTJzFpxWpGLX6XNi-CqovpGRU0K4g.png?alt=media)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://kb.bevica.com/bevica-select/opening-balances-inventory/bevica_select_-_fixed_asset_opening_balances.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.