HansaManuals

HansaManuals Home   >> Standard ERP   >> Nominal Ledger   >> Reports  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.5  

VAT Listing

---

The VAT Listing report lists the transactions that will be used to calculate the figures shown in the VAT Report. For each transaction, the total including and excluding VAT, the VAT total, the overall VAT percentage and the Currency will be shown.

This report is compiled from the Sub System records (e.g. Invoices, Purchase Invoices) that are liable for VAT. The VAT Report is compiled from the Nominal Ledger postings to the VAT Accounts. If there is a difference between the two reports, one possible reason is that the connection between a Sub System record and its related Nominal Ledger Transaction is not correct. Perhaps the Nominal Ledger Transaction does not exist at all, or perhaps the VAT Code in a Transaction row posting to a Sales or Purchase/Cost Account is incorrect or missing, in which case that row will not be included in the figure calculated by the VATRESULT or VATBALANCE commands in the VAT Report.

Period

Paste Special    Reporting Periods setting, System module

Enter the period to be covered in the report. The report will list records in the register(s) specified below with Transaction Dates that fall within this period. The first period in the Reporting Periods setting will be offered as the default value.

Number

Range Reporting    Numeric

If you want the report to list records in the register(s) specified below whose serial numbers fall within a particular range, enter that range here.

Only Registered From

If you want to list records that you entered on or after a particular date, enter that date here. In the case of a Sub System record, this refers to the date when the resulting Nominal Ledger Transaction was created (i.e. the date when you marked the Sub System record as OK).

VAT Codes (Detailed only)

Paste Special    VAT Codes setting, Nominal Ledger

The Detailed version of the report will list the rows in each Transaction and Sub System record individually. If you only need to list the rows with a particular VAT Code, specify that VAT Code here. You can also enter more than one VAT Code, separated by commas.

Specify

You can choose to have Sales Invoices, Purchase Invoices, Expenses, Receipts, Payments, inward and outgoing cash transactions, POS Balances and/or Nominal Ledger Transactions listed in separate sections in the report. You must choose at least one option otherwise the report will be blank.

The Invoices option depends on whether you are using the Post Receipt VAT option in the Account Usage S/L setting in the Sales Ledger. If you are not using this option, the report will list the Invoices issued during the report period, together with Invoice Dates. If you are using this option (i.e. your VAT calculation is based on Receipts rather than Invoices), the report will list the Invoices paid during the report period, together with the dates they were paid. The Purchase Invoices option will similarly depend on the Post Payment VAT option in the Account Usage P/L setting in the Purchase Ledger.

The Receipts option will only list Prepayments and On Account Receipts (i.e. Receipts that do not have Invoice Numbers). Similarly, the Payments option will only list Prepayments and On Account Payments.

Exclude

If you have specified that the report will list Sales Invoices and/or Purchase Invoices, use these options if you need to exclude Credit Notes and/or Cash Notes from the report.

Show totals only (Overview only)

The Overview version of the report will list each Transaction and Sub System record individually, in separate sections for each register. If you don't need to see each record listed and instead only need totals for each register, select this option.

Show Official Serial No. (P/L S/L Sorted by Branch)

If you choose to have Sales Invoices listed in the report, select this option if you need the Official Serial Number of each Invoice to be included in the report (in addition to the Invoice Number).

Select

The report can show all Transactions and Sub System records or just those with or without VAT.

Function

Use these options to determine the level of detail to be included in the report.

Overview

This option lists each transaction, showing for each one the date, number, amount excluding VAT, VAT amount, total amount, effective VAT rate and Currency. This is followed by summary totals for each VAT Code.

If you don't need the transactions to be listed and just want a single line summary of each section, use the Show Totals Only option.

Detailed

This is similar to the Overview, with the addition of VAT Code analysis for each transaction.

Reports in the Nominal Ledger:

• Introduction
  

• Definition of Nominal Ledger Reports
  

• Drill-down
  

• The Operations Menu
  

• Account Reconciliation
  

• Accrual Report
  

• Analytical Balance
  

• Analytical Balance (Fiscal purposes)
  

• Balance Sheet
  

• Bank Reconciliation
  

• Bank Statement
  

• Bank Transactions
  

• Base Currency Rate Change
  

• Budget Journal
  

• Cash Flow
  

• Chart of Accounts
  

• Correction List
  

• Corresponding Accounts
  

• Creditors Account
  

• Currency A/C Rate Change
  

• Daily Balances
  

• Debtors Account
  

• Forward Balance Journal
  

• Income & Expense Book
  

• Key Financial Ratios
  

• Liquidity Forecast
  

• Multicurrency Accounts Rate Difference
  

• N/L Accrual Transactions
  

• N/L Transfer, Subsystems
  

• Nominal Ledger
  

• Profit & Loss
  

• Revised Budget Journal
  

• Simulation Journal
  

• Tag/Object Results
  

• Tag/Object/Quantity Results
  

• Tax Account Balances
  

• Tax Calculations
  

• Tax Transactions for Registers
  

• Template Transaction Journal
  

• Test Corresponding Rules
  

• Transaction Journal
  

• Transaction Summary
  

• Trial Balance
  

• VAT Listing
  

• VAT Report
  

• VAT Report Purchases
  

• VAT Report Sales
  

• VAT Transaction Journal
  

• XBRL Report

Go back to:

• Home page for Nominal Ledger manual
  

• Home page for Standard ERP manual

Previous   Next   Top            Entire Chapter in Printable Form