2653 rfsa

From UG

(Difference between revisions)
Jump to: navigation, search
Line 19: Line 19:
Must be downloadable to excel.
Must be downloadable to excel.
-
CT number and Invoice number should be hyperlinks
+
CT number and Invoice number should be hyperlinks:  This can be mapped the same as Acc > Reports > Search Invoices.
===Report Filters===
===Report Filters===
Line 37: Line 37:
===Outputs===
===Outputs===
HTML output  
HTML output  
 +
Header should summarize filter options showing
Header should summarize filter options showing
Name of Report
Name of Report
 +
 +
Current Date (or date report was ran)
CT sailed on Month: Full name of month or CT sailed on date from: day-month-year
CT sailed on Month: Full name of month or CT sailed on date from: day-month-year
Line 47: Line 50:
Offices:  If selected.
Offices:  If selected.
-
====HTML Output Example ====
+
 
 +
====Sales Invoice Section====
 +
Name of Section:  Sales Invoices
 +
 
 +
'''Columns:'''
 +
 
 +
Issuing Office
 +
 
 +
Invoice # (as Hyperlink)
 +
 
 +
CT# (as Hyperlink)
 +
 
 +
Invoice Date
 +
 
 +
Reported Currency
 +
 
 +
Net Amount (total invoiced amount - VAT = Net Amount)
 +
 
 +
VAT Amount
 +
 
 +
Total Billed (total invoiced amount)
 +
 
 +
Note:  Net amount, VAT amount, and Total Billed Amount should be totaled at the bottom of the section
 +
 
 +
=====Purchase Invoice Sections=====
 +
 
 +
Name of Section:  Purchase Invoices
 +
 
 +
'''Columns:'''
 +
 
 +
Issuing Office
 +
 
 +
Invoice # (as Hyperlink)
 +
 
 +
CT# (as Hyperlink)
 +
 
 +
Invoice Date
 +
 
 +
Reported Currency
 +
 
 +
Net Amount (total invoiced amount - VAT = Net Amount)
 +
 
 +
VAT Amount
 +
 
 +
Total Billed (total invoiced amount)
 +
 
 +
Note:  Net amount, VAT amount, and Total Billed Amount should be totaled at the bottom of the section
 +
 
 +
======Net Payable or Recoverable======
 +
 
 +
This should display the sum of the total VAT in sales section - total VAT in purchase section.
 +
 
 +
a negative number should be displayed using ().
 +
 
 +
=======HTML Output Example=======
 +
[[File:VAT Reporting screen.JPG]]

Revision as of 21:56, 28 February 2011


Contents

Info

0002653: (Acc Report: Misc) add feature to show total VAT charges separately

Accounting needs a report to show the VAT charges separately and the net amount (amount excluding the VAT charges) for both Sales Invoices and Purchase Invoices. The report should also calculate a total Net Payable or Recoverable.

The total VAT on Sales - total VAT on Purchases = Net Payable or Recoverable.

Business Requirement

The report should have two separate sections

  • One section showing all Sales Invoices.
    • total at the bottom of all Sales Invoices.
  • One section showing all Purchase Invoices.
    • total at the bottom of all Purchase Invoices.

Must be downloadable to excel. CT number and Invoice number should be hyperlinks: This can be mapped the same as Acc > Reports > Search Invoices.

Report Filters

Date Type: (same as Acc > Reports > Profit/Loss for Multiple CT's)

Date: (same as Acc > Reports > Profit/Loss for Multiple CT's)

Offices - So the operator can select one, multiple, or all. (Check boxes have been suggested because it is only 4 choices)

Example

File:Vat Report Location.JPG File:VAT report generated.JPG

Outputs

HTML output

Header should summarize filter options showing

Name of Report

Current Date (or date report was ran)

CT sailed on Month: Full name of month or CT sailed on date from: day-month-year

CT sailed on Year: Full year displayed or CT sailed on date to: day-month-year

Offices: If selected.


Sales Invoice Section

Name of Section: Sales Invoices

Columns:

Issuing Office

Invoice # (as Hyperlink)

CT# (as Hyperlink)

Invoice Date

Reported Currency

Net Amount (total invoiced amount - VAT = Net Amount)

VAT Amount

Total Billed (total invoiced amount)

Note: Net amount, VAT amount, and Total Billed Amount should be totaled at the bottom of the section

Purchase Invoice Sections

Name of Section: Purchase Invoices

Columns:

Issuing Office

Invoice # (as Hyperlink)

CT# (as Hyperlink)

Invoice Date

Reported Currency

Net Amount (total invoiced amount - VAT = Net Amount)

VAT Amount

Total Billed (total invoiced amount)

Note: Net amount, VAT amount, and Total Billed Amount should be totaled at the bottom of the section

Net Payable or Recoverable

This should display the sum of the total VAT in sales section - total VAT in purchase section.

a negative number should be displayed using ().

=HTML Output Example=
File:VAT Reporting screen.JPG
Personal tools