You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 12 Next »
https://help.myob.com/wiki/x/gpE6Ag
How satisfied are you with our online help?*
Just these help pages, not phone support or the product itself
Why did you give this rating?
Anything else you want to tell us about the help?
Asset register in browser only
In MYOB Practice, you can import assets into the asset register from a CSV file that you exported from another system. You can only import one CSV file per import session.
Open the file using Microsoft Excel (or your preferred spreadsheet software) to check the format and amend according to the CSV file format.
We've created a template to help simplify the import process. Download this CSV Template file and open the file in your preferred spreadsheet software (e.g. Microsoft Excel). This template doesn't contain any data, so you can add your own.
While you don't need to complete all the fields for a successful import, make sure you don't delete any unused columns, or rename any column headings.
The format of the asset file toimportisa.CSV file.
The import file should include all column headings, can be in a different order. The headings are not case-sensitive.
| Column | Column headings (field name) | Mandatory or optional | Rules for the data |
|---|---|---|---|
| A | Account code | Mandatory (if there is no Asset class name) Optional (if there is an Asset class name) | Must exists in the chart of accounts. For example: myob ledger account code 744 |
| B | Asset class | Mandatory (if there is no Account code) Optional (if there is an Account code) |
For example: myob ledger asset class name motor vehicles. |
| C | Asset type | Mandatory | Must be one of the following: [not case sensitive]
|
| D | Asset code | Optional | Must be unique and less than 500 characters |
| E | asset name | Mandatory | less than 200 characters |
| F | acquisition date | Mandatory (if there is no Start date) Optional (if there is a Start date) | Date format
|
| G | cost | Mandatory | Numeric value and can't be negative. 14digits 2 decimals. can have dollars, format see spec |
| H | Start date - tax | Mandatory (if there is no Aquisition date) Optional (if there is an Aquisition date) | same as acquisition date. start date is system calculated for pools |
| I | Opening w.d.v.-TAX | opening written down value mandatory for prior year asset. spec as per cost | |
| J | Method-TAX | Mandatory | Accept the one of the following values: [not case sensitive] AUSTRALIA NEW ZEALAND |
| K | depreciation rate1-TAX | Optional | Accept value between 0% - 100% If left blank
|
| L | depreciaton rate2-TAX | Optional | value between 0 - 100% |
| M | Effect life years | Optional | value between 0-999 |
| N | Effect life months | Optional | value between 0-11 |
| O | Private Use-TAx | Optional | 0 - 100% |
| P | Accum PU-TAX | Optional | Numeric value 14digits 2 decimal points |
| Q | Is motor vehicle | Optional | can only be Y or N blank is treated as N. |
| R | Start date-ACC | the rest of the headings same spec as for tax | |
| S | Opening w.d.v-ACC | opening written downvalue - accounting mandatory for prior year asset. spec as per cost | |
| T | Method-ACC | Accept any of the following values:
| Accepts one these values (non-case sensitive)
|
| U | Depreciation rate1-ACC | value between 0 - 100%. tax depreciation rate year 1 . optional | |
| V | Depreciation rate2-ACC | value between 0 - 100%. tax depreciation rate year 1 . optional | |
| W | Private Use-ACC | 0 - 100% optinal | |
| X | Accum PU-ACC | accumulative private use, prior year. dollar amount. as per cost, optional |
- Choose a client form the Client list
- Choose Compliance from the header
- Go to > Asset register card
- Choose Add asset > Import CSV.he entries.
If the formatting of the import CSV file is incorrect, the following errors may be displayed:
- has to be a valide .csv file per the above file format spec
- has to have the header.
- all taxation headers, all accounting
The log file will list the details of the lines that failed to import and the reasons why.
If you receive any of these errors, review the format of the import file and adjust it.
Asuggestedtroubleshootingmethod,istoaddonlyonelineinitially in the text file using the correct format and confirm that this file will import successfully. Then you can import multiple lines of transactions.
Common solutions:
DDD
anynote?
Yes
No
Thanks for your feedback.