Data Volumes Table

Managing IT Projects

Data Volumes Table

Sample Document

Here is an example of a Data Volumes Table for Accounting Ledgers & Payroll

Accounting Systems Selection Project

*Sales Ledger, Sales Invoicing, Sales Orders*	*Average*	*Maximum*	*Max in 3 years time*

Number of credit customers

Number of credit sales invoices per month

Number of cash sales invoices per month

Number of sales orders per month

Number of other income receipts per month

Number of Customer remittances received per month

Number of lines per sales order

Number of lines per Invoice

Number of sales orders for goods not normally stocked (i.e..� back-to-back sales)

Number of sales statements per month

Every invoice will generate at least 1 posting to an expense account within the nominal ledger as well as VAT and control postings.

*Purchase Ledger & Purchase Orders*	*Average*	*Maximum*	*Max in 3 years time*

Number of suppliers

Number of purchase invoices per month

Number of payment remittances per month

Number of purchase orders per month

Number of lines per purchase order

Number of lines per purchase invoice

Number of supplier statements per month

Every invoice will generate at least 1 posting to an expense account within the nominal ledger as well as VAT and control postings.

*Stock Control*	*Average*	*Maximum*	*Max in 3 years time*

Number of stock lines

Number of new stock lines per year

Number of stock lines falling dormant per year

Number of stock locations

Number of goods receipts per month, i.e. GRNs

Number of Goods Inwards returned to suppliers per month

Number of goods picking lists per month

Number of picking "Substitutes" per list

Number of stock adjustments per month

Number of Stock Movements per month

Number of Despatches per month

Number of labels per despatch

Number of back orders per month


*Nominal Ledger*	*Average*	*Maximum*	*Max in 3 years time*

Number of nominal accounts

Number of cost centres

Number of cash book receipts per month (excluding sales ledger)

Number of cash book payments (excluding purchase ledger)

Number of bank receipts per month (excluding sales ledger)

Number of bank cheque payments (excluding purchase ledger)

Number of BACS payments

Number of debit/credit journal postings

*Payroll*	*Average*	*Maximum*	*Max in 3 years time*

Number of Weekly paid staff

Number of Monthly paid staff

Number of Outworkers

Number of pay elements making up Gross Pay

Number of pay deductions making up Net Pay

Number of Employee standing data changes per month

Number of Tax code changes per month

4-consulting 138 East Trinity Road, Edinburgh, EH5 3PR
Telephone: 0131 551 1035
Copyright � 2008 4-consulting

Data Volumes Table

Accounting Systems Selection Project