WinBooks on Web allows you to import accounting documents of any type (sales invoices & CN, purchase invoices & CN, miscellaneous operations or bank & cash document).
The fields bookyear and bookmonth are optional. If not present in the file, the application will ask in which book period you want to book all the transactions of the CSV file.
If they are present, they have to be filled for each row.
Field name | Type | Length | Dec. | Description |
---|---|---|---|---|
bookyear | N | 4 | Related year of the book period | |
bookmonth | N | 2 | Related month of the book period (0=open, 1=jan, 2=feb, ..., 12=dec, 13=close) | |
jnltype | C | 3 | 0 | Type of the journal:
|
jnl | C | 10 | 0 | Code of the journal |
number | N | 12 | 0 | Number of the document |
renumber | L | 1 | 0 | True (T) if the number must be renumbered (continuing the numbering of the journal in the financial package). If Wow has to renumber your documents, start your numbering to 1 and Wow will add the last number of the journal to your numbers. |
accounttyp | C | 1 | 0 | Type of account (G = general, C = customer, S = supplier) |
accountid | C | 10 | 0 | Code (number) of the account |
date | D | 8 | 0 | Date of the document (YYYY/MM/DD) |
duedate | D | 8 | 0 | Due date (YYYY/MM/DD) |
cur | C | 3 | 0 | Code of the currency (optional, blank if the amounts are given only in the base currency) |
side | C | 1 | 0 | D for Debit, C for Credit |
amountcur | N | 17 | 3 | Amount in the currency if CUR is supplied |
amount | N | 17 | 3 | Amount in the base currency |
vattype | N | 1 | 0 | Type of the V.A.T. : |
vatid | C | 6 | 0 | V.A.T. code (internal code of V.A.T. as used in WinBooks classic on WinBooks on Web) |
vatpc | N | 5 | 2 | V.A.T. % (Ex: 0.00, 6.00, 21.00) |
vatamtcur | N | 17 | 3 | Amount of the tax in the supplied cur |
vatamt | N | 17 | 3 | Amount of the tax in the base currency |
dedrate | N | 5 | 2 | Deductibility rate |
ana1 | C | 20 | 0 | Analytical code 1 |
ana2 | C | 20 | 0 | Analytical code 2 |
ana3 | C | 20 | 0 | Analytical code 3 |
ana4 | C | 20 | 0 | Analytical code 4 |
ana5 | C | 20 | 0 | Analytical code 5 |
ana6 | C | 20 | 0 | Analytical code 6 |
ana7 | C | 20 | 0 | Analytical code 7 |
ana8 | C | 20 | 0 | Analytical code 8 |
ana9 | C | 20 | 0 | Analytical code 9 |
matchnum | N | 12 | 0 | Matching number (not yet supported) |
intnote | C | 40 | 0 | Internal comment |
extnote | C | 40 | 0 | External comment |
structcom | C | 12 | 0 | Structured communication without the formatting chars 999999999999 |
costcom | C | 40 | 0 | Analytical comment |
For the cost accounting (ANA1, ANA2, ...):
- if the dimension is of type date, the format has to be YYYY/MM/DD
- if the dimension is number we have to use the point as decimal separator (nnnn.nn)