Construction Industry Accounts (CIA) Software reports
Construction Industry Accounts Software provides variety or reports that are outlined below. Please click on icons to see examples.
Contents:
- Company Reports
- Nominal Reports
- Sales Reports
- Purchase Reports
- CIS Reports
- Stock Reports
- Job Cost Reports
- Bank Reports
- Fixed Assets Reports
Extra module reports
Company – Reports:
-
VAT Return – Shows any archived/ saved VAT Returns.
-
VAT Transactions –Shows all of the transactions against archived/saved VAT Returns.
-
Successful VAT Returns –After you have submitted a VAT return you can run this report to double check that your return has been submitted (It will also give you conformation onscreen while you are submitting your return) This report also shows you the IR mark that the Inland Revenue has given your return.
-
Email Sent Report –You can double check if a sales invoice/ Customer Statement/ Remittance Advice/ Purchase Order or CIS Statement has been emailed out .
Nominal – Reports:
-
Ledger Enquiry –This report allows you to see all the transactions against a particular nominal between a date range. This would be useful if you wanted to see how a nominal balance is made up.
-
Daybook –A Nominal Daybook allows you to see all transactions that have gone through any nominal between the date range that you run the report for.
-
Trial Balance – Prints the Trial Balance.
-
Profit & Loss – Prints the Profit & Loss Report (A Report that shows the gross and net profit or loss at the date chosen)
-
Balance Sheet – Prints the Balance Sheet (A report that shows the assets, liabilities and capital of a business and giving the balance of the income and expenditure at a particular time)
-
Transactions – This report will show you the nominal transactions that have been posted between two dates, this can be split down to one ledger type, eg sales, sales receipt, purchase, bank. It shows you the debit and credit entry of the transaction.
-
Listing – A similar report to the ledger enquiry but it can be run for all nominal’s, a particular ledger eg Sales, Purchase, Bank or between two audit or batch numbers
-
List of Nominals – A report that will give you a list of all of your nominal’s within CIA, stating the code, description, the type and the group that nominal relates to.
-
List of Groups – Shows all of the nominal groups within CIA, showing the code, description and type.
Sales – Reports:
-
Ledger Enquiry –This report allows you to see all the transactions against a customer up until a certain date, or everything that is outstanding.
-
Daybook – The daybook report shows all sales invoices/applications that have been entered between the date range selected.
-
Receipt Daybook – This report shows all of the sales receipts entered into CIA between the date range selected.
-
Sales Invoice – You would go in to this report to reprint/re email a sales invoice/application
-
Invoice/Applications Due – This report shows you all invoices and applications that are due to be paid at a selected date. The report can be run for just one customer, or all customers, for just invoices, just applications or both, and can include prepayments.
-
Statements – This is a basic statement for your customers, which can be run by customer for just one job or all of their jobs. It can be run just for outstanding balances only, or everything.
-
Aged Debtors – The Aged Debtor report can be set up to run by month or by number – this can be changed through system tailoring. It can be run in summary or full form and also with or without retention.
-
Retention Diary – Shows all retention that is outstanding between the dates selected. It can be run for a range of customers/jobs and in summary or full form.
-
Unfinalised Sales Invoice – Shows you all of the un finalised (un posted) sales invoices.
-
Customer Turnover – Shows the total net amount that has been invoice/applied for between the date range.
-
Contract History – This is similar to the ledger enquiry as it will show all applications and receipts for a customer. But it can only be run for one customer and one job at any one time and will only pick up applications.
-
Customer Application Summary – Shows the applied for figure, the certified figure, any retention or discount, for each Customer and Job.
-
List of Customers – This is a list of all customers that can be run in a summary form which shows the customer code, name, contact and telephone number. Or in the full form which shows the above with address, email, fax and mobile numbers.
Purchase – Reports:
-
Ledger Enquiry –This report allows you to see all the transactions against a particular supplier up until a certain date or everything that is outstanding.
-
Daybook - The daybook report shows all Purchase invoices or applications that have been entered between the date ranges selected.
-
Payment Daybook - This report shows all of the purchase payments that have been entered into CIA between the date selected.
-
Payment List – Using the payment batch or audit numbers this report shows you all payments that have been made between the range selected.
-
Remittance Advice – This is where you would reprint/re-email a remittance advice.
-
Cheques – Here you would print your cheques on to your pre-printed cheques to give to your suppliers.
-
Aged Creditor - The Aged Creditor report can be set up to run by month or by number – this can be changed through system tailoring. It can be run in summary or full form and also with or without retention.
-
Payment Due List – Shows what invoices are due to be paid between the date range selected. It can be run for just suppliers/subcontractors or both and can include just invoices/applications/prepayments or any mixture you would like. It can also show your invoices that or on hold. Retention Diary - Shows all retention that is outstanding between the dates selected. It can be run for a range of customers/jobs and in summary or full form.
-
Subcontractor Information – This report will show you all of your subcontractor’s insurance details and CSCS registration details. When their insurance has expired the subcontractor details shows in red.
-
Invoices on Hold - This report shows you all purchase invoices that have been entered and are on hold – if an invoice is on hold it will not show on the invoice in the payment screen, so it cannot be accidently paid until it is released.
-
Supplier Turnover - Is the total net amount that has been invoice/applied for between the date range.
-
List of Suppliers - This is a list of all suppliers that can be run in a summary form which shows the supplier code, name, contact and telephone number. Or in the full form which shows the above with address, email, fax, mobile numbers and bank details.
-
List of Subcontractors - This is a list of all subcontractors that can be run in a summary form which shows the subcontractor code, name, contact and telephone number, UTR number, Deduction percentage and verification percentage. Or in the full form which shows the above with address, email, fax, mobile numbers and bank details.
-
Contract History - This is similar to the ledger enquiry as it will show all applications and receipts for a particular customer. But it can only be run for one supplier and one job at any one time and will only pick up applications.
CIS – Reports:
-
CIS monthly Return – You can view and print any saved CIS returns in this screen
-
CIS Payment List - The payment list can be run for one subcontractor or all subcontractors, and it will show you all of their payments between the date range selected, it will also split out and show you the payments that have already been on a return and the ones that haven’t.
-
CIS Statement – The Subcontractor statement can only be run after your CIS return has been saved. It shows all of the standard subcontractor details that has got to go on a return along with their payment totals for that month.
-
Subcontractor Tax Liability – Can be run between two dates and will give you a total, per subcontractor, of their gross pay between those dates, the material content, their taxable figure and their tax taken.
-
Successful Monthly Return – This report proves that the Inland Revenue has received your CIS Return and will show you the IR Mark that they have given you return.
Stock – Reports:
-
Transactions – Very similar to a daybook, this shows all of the stock transactions that have been entered between the dates selected.
-
List of Stock – Is a list of all of the stock items, their location, price and stock level between the date range selected.
Job Cost – Reports:
-
Job Cost Daybook - The daybook report shows all transactions that have been job costed between the date ranges selected.
-
Job Cost Report by Date – Shows you all transactions against a particular job, between the date range selected.
-
Job Cost Report by Analysis – This report shows all transactions for the job it has been run for, but is grouped by analysis code, giving you a total per code & also showing the budget.
-
Job Cost Report with Rate – Will multiply the quantity for a particular analysis code by the rate that you enter at the top of the report. This is useful if you want a full job cost report with all of your analysis codes, but you want to increase the total of one analysis code.
-
Job Cost Report Summary – Gives you a summary of costs and revenue per job. Shows one line per analysis code with the total amount of the transactions. It also shows you the budget per analysis code and the difference between your budget and actual costs.
-
Job Cost Report Filtered – Allows you to search and see specific information, using different filter headings. You can run it for one or multiple jobs, you can chose the analysis code, audit number, search for a supplier or employee or description, or just for one particular ledger (eg sales, sales receipt, purchase etc)
-
Job Cost Report Multiple Jobs – This report can be run for multiple jobs and shows you the total amount per analysis code, for each job. It also totals the costs and revenue per job & as a total for all jobs.
-
Job Value Report – This report shows the total costs and total revenue per job, it then calculates the profit/loss on the report. This report can also be run by the key data fields.
-
Job Cost Report (Filtered) - Allows you to run the job cost report for single or multiple jobs, and for up to 2 analysis codes. It will then show you the analysis code as a percentage of the sales. It also shows you total profit and total costs per job.
-
Job Cost Report (to date) – This job cost report allows you to see the cost, revenue and profit per job between the date range you ask for at the top of the report (this period) and also to date.
-
Job Subcontractors – Thejob subcontractors report will split down each job and list all subcontractors that have worked on that job (for Applications only). It shows you the amount of money that has been applied for, what has been certified/paid, any outstanding retention, the total discount, and balance of the applications.
-
Statements – This produces one statement per job, and shows all invoices/applications against that job for the customer. It shows the total invoice amount and then the balance on each invoice.
-
WIP Report – Shows the total cost and revenue for each job between the selected dates. It calculates the work in progress as the Revenue less the costs.
-
Committed Cost Report – Shows you the actual costs per analysis code, costs entered via invoices, applications, payroll and costings. It also then shows the committed costs per analysis code, committed costs are costs that have been entered via purchase orders, that have yet to be matched to an invoice.
-
Budget Analysis – This report shows your actual costs against the budget per job and the variation between the two. It can be run for one customer or all customers, for one particular job, or all jobs.
-
Budget Analysis Filtered – This report can be run for all or just one customer and for one or all jobs. But only for one analysis code. It shows the actual amount against the analysis code and the budget.
-
Employee by Job – This report lists all jobs, and which employees have worked on each job for the particular week/month number it has been run for.
-
Job by Employee - This report lists all employees and then each job that they have worked on for the particular week/month number the report has been run for.
-
Jobs without Sales Invoices – Gives you a list of all the jobs that have been set up within CIA that do not have sales invoices against them.
-
Analysis Costs – This report will show you the total cost or revenue per analysis code for the jobs selected. It does not split it down per job, but shows you an overall total per analysis code.
-
List of Jobs - This is a list of all jobs that have been entered in to the programme, it can be run just for one customer or all, and include or not include archived jobs. It shows the job code, name, site address, site telephone number, the customer code, name and telephone number. It can also be run by the key data fields.
-
List of Analysis Codes – The lists all of the analysis codes that have been set up for the selected job. Showing their code, description and budget if one has been entered.
-
Employee Productivity – This report splits out each employee and which jobs they have worked on. It shows the total number of labour hours on the job, and then of that the total number of hours each employee has spent on it. Giving you the employee revenue and their cost per hour.
Bank – Reports:
-
Daybook – Shows you all transactions that have been entered through bank payments or bank receipts and splits it down per bank account.
-
Bank Reconciliation – After you have picked your bank account and reconciliation dates, this report shows you all of the un-reconciled transactions with the transaction date, ledger type, audit or batch number, description and amount. There is a tick box at the top of the screen if you wanted to also show your reconciled transactions.
-
Bank Balance – The bank balance report shows you the bank opening balance figure, the total transactions that have gone through the bank and then also the closing bank balance all worked out from the date range you enter at the top of the screen.
Fixed Assets – Reports:
-
Fixed Asset Register – Gives you a list of all of the fixed assets entered within CIA, it shows the bought forward amount, the depreciation between the dates entered and the Net Book Value.
-
report_fixed_assets.jpg
List of Fixed Assets – Is a list of all of your fixed assets you had at the date selected. It shows the initial cost, the total depreciation up to the date entered and the Net Book Value.
Purchase Order – Reports:
-
Print Purchase Order - This report allows you to re print/email a Purchase Order at a later date.
-
Purchase Order Report – The Purchase Order Report is broken down by supplier, and lists all of the open Purchase Orders linked to that supplier, showing the unit cost, unit quantity, order quantity, invoice quantity (what has already been turned in to an invoice) and quantity left (what has yet to be invoiced)
-
Purchase Order Report (Filtered) – This report allows you to filter the information that you want to see. You can search on the description filed, order number, dates and supplier
-
Purchase Order Report (with Invoice) - Shows you the details on your purchase order along with the invoice details after it has been turned in to an invoice.
-
Print Price List - You can set up a price list within the purchase order section, which allows you set up the items you order from different suppliers with the costs for each item. This report will give you a list of all of the items you have entered.
Works Order – Reports:
-
Works Order – This report will re-print your Works Order, so long as you know either the audit number, the batch number or the Works Order number.
-
Works Order Report – This will list you all of the Works Orders selected. Either by Works Order numbers, Customer Order Numbers, by property, customer, or between start or finish dates.
-
Cost Analysis – This report breaks down each Works Order and lists al of the analysis codes that it has been costed against. It can be run by a date range, a job range, customer or property range.
Schedule of Rates – Reports:
-
Schedule of Rates Items – This report gives you a list of the items and their rates that have been set up to be included in works orders.