Report Data Sources

Custom Reports can pull live data from 17 sources in your Assignar Pay account. Each source has its own set of filters and columns. This page is a reference — use it when you are building a report and need to know which source to pick and which filters it supports.

If you are new to Custom Reports, start with the Custom Reports guide for instructions on how to import and work with data.

How Data Sources Work

When you click Import → Import from data source in the report editor:

1. You pick a data source from the side panel (the 17 listed below).
2. A configuration dialog opens where you set filters (date range, client, project, and so on) and choose columns to include.
3. You click Import to Current Sheet.
4. Up to 10,000 rows are loaded into your active sheet. If your filters would return more rows, narrow them further (for example, by month) and import in batches.

Every data source supports the same column picker: tick the columns you want, untick the ones you do not, and use Select All or Deselect All to move quickly.

Once imported, the sheet tab turns blue and a Connected Data Source bar appears above the spreadsheet. You can then refresh the data, change the filters, or disconnect the link at any time.

Categories

The 17 sources are grouped into six categories in the side panel:

Financial

Invoices

All issued invoices with amounts, dates, and statuses.

• Filters: Date Range, Client, Project
• Typical columns: Invoice #, Client, Project, Amount, Tax, Total, Status, Issue Date, Due Date, Type, Contract, Subtotal, Notes

Use this source for revenue reporting, ageing analysis, and client-level summaries.

Invoice Line Items

The individual line items that make up each invoice.

• Filters: Date Range, Client, Project, Cost Code
• Typical columns: Invoice #, Description, Qty, Unit Price, Amount, % Complete, Cost Code, Previous Billed, Current Billed, Timesheet Based, Source Type

Use this source when you need to reconcile billing against cost codes, or when you want a detailed breakdown of what was invoiced.

Supplier Invoices

Invoices received from suppliers against purchase orders.

• Filters: Date Range, Supplier
• Typical columns: Invoice #, Supplier, PO #, Subtotal, Total, Status, Invoice Date, Due Date, Paid Date, Payment Reference, Approved Date

Use this source for accounts-payable tracking and supplier spend analysis.

Labor & Payroll

Timesheets

Worker timesheets with hours, rates, and billing details.

• Filters: Date Range, Client, Project, Employee
• Typical columns: Employee, Project, Client, Date, Hours, Rate, Total, Cost Code, Status, Notes

Use this source for labour-cost reporting, productivity analysis, and billable-hours summaries.

Pay Rates

Pay rate schedules by client and project.

• Filters: Date Range, Client, Project
• Typical columns: Employee, Client, Project, Role, Rate, Effective From, Effective To, Status

Use this source when auditing pay-rate coverage or preparing rate reviews.

Employee Pay Items

Individual pay items assigned to employees (allowances, bonuses, deductions).

• Filters: Employee, Cost Code
• Typical columns: Employee, Pay Item, Amount, Frequency, Cost Code, Effective Date

Use this source to review payroll additions and adjustments in detail.

Procurement

Purchase Orders

All purchase orders with totals and delivery details.

• Filters: Date Range, Supplier, Project
• Typical columns: PO #, Supplier, Project, Status, Subtotal, Tax, Total, Order Date, Expected Delivery, Notes

Use this source for supplier spend, order status dashboards, and delivery tracking.

PO Line Items

Individual line items from purchase orders.

• Filters: Supplier, Project, Cost Code
• Typical columns: PO #, Description, Qty, Unit Price, Total, Cost Code, Status

Use this source when analysing procurement by cost code or reconciling line-level PO data.

Orders

Work orders with contract values and scheduling.

• Filters: Date Range, Client, Project
• Typical columns: Order #, Client, Project, Contract Value, Status, Start Date, End Date

Use this source for contract-level revenue tracking and order-pipeline reporting.

Order Line Items

Budget vs. actual line items from work orders.

• Filters: Client, Project, Cost Code
• Typical columns: Order #, Description, Budget Qty, Actual Qty, Budget Amount, Actual Amount, Variance, Cost Code

Use this source for budget-vs-actual cost reports and variance analysis.

Job Costing

Cost Codes

The master list of cost codes with categories and pricing.

• Filters: Category
• Typical columns: Code, Description, Category, Subcategory, Unit, Rate, Status

Use this source to audit your cost-code structure or to join cost-code master data into other reports.

Schedule of Values Items

Progress billing line items from your schedules of values.

• Filters: Client, Project
• Typical columns: Project, Code, Description, Scheduled Value, Previous Billed, Current Billed, Total Completed, % Complete, Balance

Use this source for progress-billing reports, retention tracking, and cash-flow forecasting.

Forms

Form Submissions

Responses to custom forms. Columns adapt to the form you select — each question on the form becomes a column in the output.

• Filters: Form (required — pick the form first), Date Range, Status
• Typical columns: Submission Date, Submitted By, Status, Project, plus one column per form field

Use this source to analyse site diaries, safety checks, inspections, or any custom data captured through forms.

Tip: If the column list looks empty when you open the dialog, make sure you have selected a form first. The columns refresh based on the form's schema.

Reference Data

These four sources are your master data — handy for lookups and for joining into other reports.

Projects

All projects with client, region, and schedule details.

• Filters: Client, Date Range
• Typical columns: Project, Client, Status, Region, Start Date, End Date, Budget, Manager

Clients

Your client directory.

• Filters: None
• Typical columns: Client, Contact, Email, Phone, Address, Tax ID, Status

Employees

Your employee directory.

• Filters: None (the field list is shown in the dialog — leave everything ticked for a full roster)
• Typical columns: Employee, Role, Department, Start Date, Status, Email, Phone

Suppliers

Your supplier directory.

• Filters: None
• Typical columns: Supplier, Contact, Email, Phone, Address, Tax ID, Payment Terms, Status

Date Range Presets

Several data sources (Invoices, Timesheets, Purchase Orders, Orders, Form Submissions, and others) support a date range filter. Inside the filter you can type dates directly, or choose one of these presets for speed:

• This Month — 1st of the current month to today
• This Quarter — start of the current calendar quarter to today
• Year to Date — January 1st of the current year to today
• Last Year — January 1st to December 31st of the previous year
• Custom Range — type any start and end date

If you use a preset, the preset name is stored with the connection. When you click Refresh later, the range is recalculated from today's date — so a "This Month" report automatically shows the new month's data each time you refresh.

Common Patterns

Combining Two Data Sources on Separate Sheets

Create a sheet named "Invoices", import the Invoices data source. Add a second sheet named "Timesheets", import the Timesheets data source filtered to the same date range. Add a third sheet named "Summary" and use formulas like =SUM('Invoices'!G:G) and =SUM('Timesheets'!E:E) to roll up the totals side by side.

Adding Your Own Columns Alongside Imported Data

Once data is imported, you can add your own columns to the right of the imported data — formulas, notes, or lookup values. When you refresh the data source, the imported columns are replaced but your formulas stay in place as long as you keep them outside the imported range.

Layering Reference Data

Import a transactional source (say, Invoices) onto one sheet. Import the Clients reference data onto another sheet. Use VLOOKUP to pull client contact details into the Invoices sheet: =VLOOKUP(B2, Clients!A:F, 3, FALSE).

Related Guides

• Custom Reports — full guide to building, saving, and refreshing Custom Reports