VAT report

This section describes the VAT report.

Printing VAT statements

To print VAT statements, select Home/Print/Print from the menu bar or the corresponding icon in the VAT periods table. VAT statements can be printed for one or more terms by selecting the relevant terms before printing the statements.

Visma Business does not print VAT statements for terms for which there has been no flow.

Closing VAT periods

After the VAT statement has been printed (not print previewed), the VAT control dialog box is displayed with the following options:

Generate batch
Update the batch
Move suspension date

All options will be checked when you enter the dialog box. This is the case if you have checked VAT control in the dialog box for the Accounting instances field in the Bedriftsopplysninger table. Visma Business creates a batch and updates it directly, unless you remove the checks for the Generate batch and Update the batch options. Alternatively, you can remove the check for the Update the batch option. The batch must then be manually updated in the Batches table at a later stage.

Merk: You will not be able to close the VAT periods if you remove the check for the Generate batch option.

If you choose to update the batch directly, you can also check Move suspension date. This prevents anyone from posting vouchers to VAT periods which are closed. If you remove the check in the Move suspension date field, the suspension date can be moved later on using the Processing/Move suspension date option in the Bedriftsopplysninger table.

When printing zero reports, Move suspension date is updated without a batch being generated.

If you do not want to approve the VAT statement, select Cancel (or press the Esc key). If you select OK, the printout is approved and the VAT period closed.

Before printing and approving the VAT statement, you should check the statement by selecting Home/Print/Print preview from the menu bar or corresponding icon. Any errors must be corrected using a correction voucher to ensure that all sales figures, basic figures and calculated taxes are correct.

If errors arise during approval/closing

If transaction errors arise during the approval of printed VAT statements, Visma Business cancels locking of the VAT periods and, if possible, resets the VAT statement series. 0 rows approved will be displayed on the status bar. In this way, you avoid having partially updated data after, for example, an abnormal interruption. The condition for this is that you have enabled Other process menu options in the dialog box for the Database transactions field in the Bedriftsopplysninger table.

Posting of VAT control

Visma Business generates one batch for each VAT period. The amounts for each tax rate in the tax accounts (input VAT, EU VAT, output VAT and investment tax) are transferred to the VAT control account. The basis for the investment tax is also balanced and produces a corresponding difference between the total entered as debit and credit in the batch.

Voucher number and voucher type are transferred from the voucher series for VAT statements, to which you have referred in the Bedriftsopplysninger table. The VAT control account is also transferred from the Bedriftsopplysninger table. Value date and voucher date are set to the expiry of the VAT period and the batch is given code of origin 3 (VAT statement).

Editing VAT statement forms

VAT statement forms are selected in the dialog box for the Home/Print/Page setup menu item in the VAT periods table. The standard Visma Business layout contains a suggested VAT statement with form number 1. This is contained in the Forms table. If you select Processing/Graphical editing from the menu bar in the Forms table, an edit window is displayed with set texts and macros for the VAT statement. These can be used to edit and customise the VAT statement to suit your company.

The VAT statement requires certain information relating to calculated taxes and the tax base, in addition to the general macro functions. These are stored as element type text, either on their own or combined with text you enter. The macro functions can be selected directly from the help screen displayed by entering * or double-clicking in the field.

Visma Business performs continuous syntax checking, changing the colour of the macro functions from black to blue when Visma Business recognises them and all parameters entered are correct. A text can be spread over several lines, with automatic line breaks in relation to the element length. If necessary, Visma Business divides lines on spaces, hyphens or the special word separation character ^. A new line can be forced with the character |.

Macro Functions

@System (Field name): This macro is used to print fields from the System information table, for example the name and address of the system owner (the licensee).
@Firm (Field name): This macro is used to put information about the company in the statement. You can choose from all the fields in the Bedrift table and in the Bedriftsopplysninger table.
@VAT period start date: You use this macro to export the VAT period start date. The date is retrieved from the From date in the Accounting periods table.
@VAT period end date: You use this macro to export the VAT period end date. The date is retrieved from the To date in the Accounting periods table.
@Date(): This macro returns the date the printout commenced.
@User (Field name): This macro can be used to put information about the user in the statement, for example @User (Name) to print the name of the user.
@Page no. (Level): This macro should normally have 1 as the parameter when you print statements which consist of several isolated pages. The page numbers will then start from the beginning for each main connection level. 0 or no parameter results in the pages being consecutively numbered.
@Free text (Free text no.): This macro can be used to present texts in the appropriate language. Rows for one or more languages are inserted via the Free text text type in the Texts table. The parameter for the macro is set equal to the Text no. field in the Texts table.
@Time (): This macro returns the time the printout commenced.
@VAT period (): The macro shows the VAT period and VAT year to which the VAT statement applies. VAT statements can be printed for one or more terms. Each period is printed on a new page, provided the page break level is set to 1 in the Page setup dialog box.
The text can be overridden in the Texts table (heading text 4).
@PostedAmount (Account no.): You can use this macro to return the posted amount for the account entered for the VAT period covered by the VAT statement.
@SwitchPostedAmount (Account no.): You can use this macro to return the posted amount with the preceding sign reversed for the account entered for the VAT period covered by the VAT statement.
@VATAmount (Account no.): You can use this macro to return the VAT amount for the account entered for the VAT period covered by the VAT statement.
@SwitchVATAmount (Account no.): You can use this macro to return the VAT amount with the preceding sign reversed for the account entered for the VAT period covered by the VAT statement.

Macro functions per turnover class

The following macro functions correspond to related turnover classes in general ledger transactions and capital asset transactions and show the total amount for the current VAT period:

@DutiableSales()
@DutyFreeSales ()
@TransfToEU ()
@SaleOfGoodsToEU ()
@SaleOfGoodsAbroad ()
@SaleOfServAbroad ()
@DutiablePurchase ()
@DutyFreePurchase ()
@TransfBetwOtherEUCountr ()
@PurchOfGoodsFromEU ()
@PurchOfGoodsAbroad ()
@PurchOfServAbroad ()
@OutsideScopeVATSales()
@OutsideScopeVATPurch()

@PaidVAT (VAT no.) and @TotalPaidVAT (): These macro functions are used to return output VAT for a particular VAT number from the VAT table and in total respectively.
@InvTaxBase (Inv. tax no.): This macro function returns the base for a particular investment tax from the Investment tax table.
@InvTax (Inv. tax no.) and @TotalInvTax (): These macro functions return the investment tax for a particular investment tax from the Investment tax table and in total respectively.
@ReceivedVAT (VAT no.) and @TotalReceivedVAT (): These macro functions are used to return input VAT for a particular VAT number from the VAT table and in total respectively.
@EUVAT (VAT no.) and @TotalEUVAT (): These macro functions return fictitious EU VAT for a particular VAT number from the VAT table and in total respectively.

EU VAT

Merk: This section only applies to EU member states and describes how EU VAT is entered and reported.

Purchases from EU countries

Create a separate VAT account in the general ledger for input EU VAT.
Create a VAT number in the VAT table and fill in the VAT rate for domestic VAT. Visma Business uses this rate to calculate output VAT and to deduct input VAT. Enter the correct general ledger accounts for the EU VAT account and input VAT.
Create a VAT code in the VAT codes table with VAT type 2 (Input VAT from other EU countries) and fill in the correct VAT number.
Open the General ledger table and link this VAT code to the general ledger accounts for purchases from EU countries. The VAT class for these accounts should be set to 6 (Purchases from EU countries).

Sales to EU countries

The accounts for sales to EU countries must be created with VAT class 5 (Sales to EU countries) and linked to a VAT code which does not add VAT.

VAT report

You must adapt the figures in the VAT statement to the EU standard. The example below shows the fields that must be included in VAT statements in Sweden:

Paid VAT 25%	@ PaidVAT(VAT no)
Paid VAT 21%	@ PaidVAT(VAT no)
Paid VAT 12%	@ PaidVAT(VAT no)
Output VAT on purchases from EU countries	@ EUVAT(VAT no)
Input VAT	@ReceivedVAT ()
Unpaid VAT	=@TotalPaidVAT() + @TotalInvTax () - @TotalReceivedVAT () - @TotalEUVAT ()
Dutiable domestic turnover	@DutiableSales()
Duty free domestic turnover	@DutyFreeSales ()
Export turnover (not EU countries)	@Export()
Sales to EU countries	@SalesToEU ()
Purchases from EU countries	@PurchaseFromEU()

In addition the report should include who the buyer is and the sales price. This report must be defined on the basis of the sales history.

Voucher registration

Invoices from EU countries must be entered without VAT on the voucher. VAT is calculated by the invoice recipient and then deducted by you (provided that you can deduct the full amount). These operations are carried out automatically when you use the correct VAT codes.

Merk: You can only use duty free sales to EU countries if you know the customer's VAT number. You must specify your own VAT number and the customer's VAT number.