The reports
| Report (title) | Shows |
|---|---|
| VAT Purchase Summary Report | One row per bill, supplier or product in the period: date, bill number, supplier, PAN, total purchase or import, tax exempted, taxable amount and VAT, with the import columns |
| VAT Purchase Detail Report | The same by product line: each product with its quantity, unit and the same amounts |
| VAT Purchase Return Summary Report | The purchase returns of the period, as negative amounts |
They are in the VAT Reports group of the reports menu and need the VAT reports permission.
How to read a row
| Column | Meaning |
|---|---|
| Date, Bill no | The supplier's bill date and number (Party invoice date and Party invoice no of the purchase invoice), or your own voucher number and date where the supplier's are empty |
| Supplier, PAN | The supplier's name and PAN. A cash purchase shows the name and PAN typed on it |
| Total purchase/Import | The purchase's value without VAT: taxable plus tax exempted |
| Tax exempted | The part of the bill on products or lines that carry no VAT |
| Taxable amount | What VAT was paid on |
| VAT | The VAT amount, from the adjustment named as Purchase vat adjustment in Configuration |
| Import taxable amount, Import tax exempted, Import VAT, Line of Credit (LC) no | For an import purchase: the amounts from its Import details tab and its pragyapan patra number (Record an import purchase) |
| Taxable capitalized purchase / import, Tax on capitalized purchase / import | Fixed-asset purchases, in the Bill Wise and Product Wise views |
Choose what to include
| Choice | Effect |
|---|---|
| Report group by | Bill Wise, Supplier Wise or Product Wise |
| VAT report format | IRD or Normal |
| Include debit and credit note | Adds the debit and credit notes that carry a taxable amount (Issue a debit note, Issue a credit note) |
| Include return | Adds the purchase returns as negative rows (Return goods to a supplier) |
| Include journal voucher | Adds journal lines marked Show on VAT register (on by default) (Make adjustments with a journal voucher) |
| Based on party invoice info | Uses the supplier's own bill number and date; switch it off to list your own voucher numbers |
| Taxable greater than or equals 100000 | Lists only the purchases of one lakh or more |
The filters are From date (the VAT period), Supplier, Bill no, PAN, Total purchase/Import, Taxable amount, VAT and Line of Credit (LC) no.
Add-on bills that are marked Show on VAT register on a purchase add-on voucher also appear, as their own rows (Add a cost to a purchase with an add-on voucher).
Common questions
A VAT bill I booked by journal voucher is missing.
Check that Include journal voucher is on, and that on the journal Show on VAT register is switched on for the VAT line, with its Taxable amount (Make adjustments with a journal voucher).
A fixed-asset purchase is not in the capitalized columns.
Those columns are filled in the Bill Wise and Product Wise views. The Supplier Wise view lists a fixed-asset purchase with the ordinary purchases.