CIA Software Features

Construction Industry Accounts (CIA) Software reports

Reports generated by Construction Industry Accounts Software

Construction Industry Accounts Software provides variety or reports that are outlined below. Please click on icons to see examples.
 

Company – Reports:

  • See an example VAT ReturnShows any archived/ saved VAT Returns.
  • See an example VAT TransactionsShows 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 EnquiryThis 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 BalancePrints the Trial Balance.
  • Profit & LossPrints the Profit & Loss Report (A Report that shows the gross and net profit or loss at the date chosen)
  • See an example Balance SheetPrints 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)
  • TransactionsThis 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.
  • ListingA 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 NominalsA 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 EnquiryThis report allows you to see all the transactions against a customer up until a certain date, or everything that is outstanding.
  • See an example DaybookThe daybook report shows all sales invoices/applications that have been entered between the date range selected.
  • See an example Receipt DaybookThis report shows all of the sales receipts entered into CIA between the date range selected.
  • See an example Sales InvoiceYou 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 StatementsThis 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 DebtorsThe 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 DiaryShows 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 InvoiceShows you all of the un finalised (un posted) sales invoices.
  • See an example Customer TurnoverShows the total net amount that has been invoice/applied for between the date range.
  • See an example Contract HistoryThis 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 SummaryShows the applied for figure, the certified figure, any retention or discount, for each Customer and Job.
  • See an example List of CustomersThis 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 EnquiryThis 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 ListUsing the payment batch or audit numbers this report shows you all payments that have been made between the range selected.
  • See an example Remittance AdviceThis 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 ListShows 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 InformationThis 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 ReturnYou 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 StatementThe 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 LiabilityCan 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 TransactionsVery similar to a daybook, this shows all of the stock transactions that have been entered between the dates selected.
  • See an example List of StockIs 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 DateShows you all transactions against a particular job, between the date range selected.
  • See an example Job Cost Report by AnalysisThis 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 RateWill 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 SummaryGives 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 FilteredAllows 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 JobsThis 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 ReportThis 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 SubcontractorsThejob 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 StatementsThis 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 ReportShows 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 ReportShows 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 AnalysisThis 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 FilteredThis 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 JobThis 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 InvoicesGives 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 CostsThis 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 CodesThe 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 ProductivityThis 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 DaybookShows you all transactions that have been entered through bank payments or bank receipts and splits it down per bank account.
  • See an example Bank ReconciliationAfter 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 BalanceThe 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 RegisterGives 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 AssetsIs 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 OrderThis 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 ReportThis 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 AnalysisThis 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 ItemsThis report gives you a list of the items and their rates that have been set up to be included in works orders.