CIA Software Features

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:

Extra module reports

Company – Reports:

  • See an example VAT Return – Shows any archived/ saved VAT Returns.
  • See an example 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:

  • See an example 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.
  • See an example 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)
  • See an example 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
  • See an example 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.
  • See an example List of Groups – Shows all of the nominal groups within CIA, showing the code, description and type.

Sales – Reports:

  • See an example Ledger Enquiry –This report allows you to see all the transactions against a customer up until a certain date, or everything that is outstanding.
  • See an example Daybook – The daybook report shows all sales invoices/applications that have been entered between the date range selected.
  • See an example Receipt Daybook – This report shows all of the sales receipts entered into CIA between the date range selected.
  • See an example Sales Invoice – You would go in to this report to reprint/re email a sales invoice/application
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example Unfinalised Sales Invoice – Shows you all of the un finalised (un posted) sales invoices.
  • See an example Customer Turnover – Shows the total net amount that has been invoice/applied for between the date range.
  • See an example 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.
  • See an example Customer Application Summary – Shows the applied for figure, the certified figure, any retention or discount, for each Customer and Job.
  • See an example 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:

  • See an example 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.
  • See an example Daybook - The daybook report shows all Purchase invoices or applications that have been entered between the date ranges selected.
  • See an example Payment Daybook - This report shows all of the purchase payments that have been entered into CIA between the date selected.
  • See an example Payment List – Using the payment batch or audit numbers this report shows you all payments that have been made between the range selected.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example Supplier Turnover - Is the total net amount that has been invoice/applied for between the date range.
  • See an example 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.
  • See an example 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:

  • See an example CIS monthly Return – You can view and print any saved CIS returns in this screen
  • See an example 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.
  • See an example 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.
  • See an example 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:

  • See an example Transactions – Very similar to a daybook, this shows all of the stock transactions that have been entered between the dates selected.
  • See an example 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:

  • See an example Job Cost Daybook - The daybook report shows all transactions that have been job costed between the date ranges selected.
  • See an example Job Cost Report by Date – Shows you all transactions against a particular job, between the date range selected.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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)
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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.
  • See an example 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:

  • See an example Daybook – Shows you all transactions that have been entered through bank payments or bank receipts and splits it down per bank account.
  • See an example 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.
  • See an example 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:

  • See an example 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
    See an example 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:

  • See an example Print Purchase Order - This report allows you to re print/email a Purchase Order at a later date.
  • See an example 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)
  • See an example 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
  • See an example 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.
  • See an example 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:

  • See an example 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.
  • See an example 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.
  • See an example 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:

  • See an example 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.