1. Home
  2. Billing
  3. Projects
  4. Project Statement Tab

Project Statement Tab

๐Ÿ“Š The Project Statement tab gives you a complete, real-time financial picture for a single project โ€” covering invoices, payments, credit notes, refunds, and outstanding balances linked to that project. It is the project-level counterpart of the Client Statement, and the go-to view for billing reviews, client conversations, and internal audits.

๐Ÿ“ Screen: Billing โ†’ Projects โ†’ click any project row to open the Project aside โ†’ switch to the Statement tab. Use the Print button at the top-right of the tab to export the entire statement as a branded PDF (file name auto-generated from the project’s name).

๐Ÿ” Purpose

  • Provide a real-time financial summary for each project.
  • Help project managers and finance teams monitor billing, collections, and dues at the project level.
  • Serve as a ready reference for client discussions and internal audits.

๐Ÿ“Œ Currency note: all amounts on the Project Statement tab are displayed in the client’s billing currency, with the currency symbol shown next to each KPI. There is no auto-conversion to your tenant’s primary currency. Currency is set on the Client record (not on the project), so two projects under the same client always share the same statement currency. Edit it from Billing โ†’ Clients โ†’ Edit.

๐Ÿงฉ Sections in the Project Statement

๐Ÿ“ Project Overview

Displays high-level information at the top of the tab:

  • Company โ€” the client’s company / organisation name.
  • Client โ€” primary contact (avatar + first + last name).
  • Project Name โ€” name of the project this statement belongs to.
  • Owner โ€” internal project owner / manager responsible for delivery.
  • Type, Category, Status โ€” project classification chips.
  • Currency โ€” billing currency inherited from the client record.
  • Project Cost โ€” agreed project cost / estimate as captured on the project record.

๐Ÿ“Š Financial Summary KPIs

Four headline KPI cards summarise the project’s running balance, each prefixed with the client’s currency symbol:

  • Invoiced Amount โ€” total of all invoices raised for this project.
  • Uninvoiced Amount โ€” billable items that exist on the project but have not yet been pulled into an invoice.
  • Paid Amount โ€” sum of payments received and applied against this project’s invoices.
  • Unpaid Amount โ€” outstanding receivable still expected on this project.

๐Ÿ“ฆ Billable Items

Every billable item raised on the project, regardless of whether it has been invoiced yet.

ColumnDescription
DateDate the billable item was logged.
ProjectProject to which the billable item belongs (always the current project on this tab).
Billed ItemsTitle / description of the service or product billed.
InvoicedStatus badge โ€” Invoiced (green) when pulled into an invoice, Uninvoiced (amber) when still pending.
Net AmountItem amount before tax.
TaxTax amount on the line.
TotalNet + Tax.
Invoice No.Linked invoice number (blank for uninvoiced items).

๐Ÿงพ Invoices

Every invoice raised against this project. Direct Client Invoices (created without a project) do not appear here โ€” they only show up on the Client Statement tab.

ColumnDescription
DateInvoice issue date.
Invoice No.System-generated unique invoice number.
StatusPayment status badge โ€” Paid, Partial, Unpaid, Draft, or Cancelled. Cancelled invoices show a red badge with a strike icon.
Due StatusAging indicator on Unpaid / Partial invoices โ€” Due (still inside due date) or Overdue ยท N day(s) (past due). Cancelled invoices show “Cancelled” here too.
ProjectLinked project name (always the current project on this tab).
Net AmountInvoice total before tax.
TaxTotal GST / tax on the invoice.
TotalNet + Tax (grand total).
OutstandingAmount still due on this invoice. Highlighted in red when > 0; cancelled invoices always show 0.

๐Ÿ’ฐ Payments

Every payment receipt logged against this project’s invoices.

ColumnDescription
Payment NumberUnique system-generated payment ID.
Invoice NumberInvoice to which the payment was applied.
Payment DateDate the payment was received.
Invoice AmountTotal value of the linked invoice.
Amount PaidAmount the client actually paid.
Xction FeesTransaction / gateway fees applied to this receipt (if any).
Amount ReceivedNet amount applied to the invoice after deductions.
ModePayment mode chip โ€” Cash / Bank / UPI / Other.
Reference NoBank reference, UTR, or other proof of payment.

๐Ÿ“Œ Transaction Fees โ€” “Borne By” matters: if fees are borne by the Client, the fee reduces the credit applied to the invoice (so Amount Received is less than Amount Paid). If fees are borne by Us (the company), the full Amount Paid credits the invoice and the fee is posted separately as a Bank Charges expense โ€” Amount Received equals Amount Paid in that case.

๐Ÿ’ณ Credit Notes

Every credit note raised against this project’s invoices. The single Credit column shows the remaining credit balance still available to apply against future invoices or refund.

ColumnDescription
DateIssue date of the credit note.
Credit NoteUnique credit-note number.
Invoice No.Linked invoice (the invoice the credit note was issued against).
Debit Note No.Linked debit-note number, if any.
Total AmountOriginal face value of the credit note.
CreditRemaining unapplied credit available against this credit note. Already net of applied + refunded amounts โ€” do not subtract those again. Cancelled credit notes show 0.
StatusShows Cancelled in red for voided credit notes; active credit notes leave this column blank.

๐Ÿ” Refund

Every refund disbursed against this project (typically against a credit note).

ColumnDescription
Refund NumberUnique system-generated refund ID.
Refund DateDate the refund was processed.
AmountRefunded amount (shown in red as it is money flowing out).
Transaction IDPayment-gateway / bank reference for the refund.
Invoice No.Invoice associated with the refund (if any).
CreditNote No.Credit note from which the refund was drawn.

๐Ÿ“š Ledger

Chronological transaction history for the project, presented as two grouped sub-ledgers side-by-side:

  • Outstanding Table โ€” tracks the receivable balance: invoices increase Outstanding, payments & applied credit notes decrease it.
  • Cash Balance Table โ€” tracks the project’s advance / unapplied credit: excess payments and unapplied credit notes increase the balance, and the balance decreases when it is later used against new invoices or refunded.
DateID NoRef NoTypeDescriptionOutstanding TableCash Balance Table
DebitCreditOutstandingDebitCreditBalance
DD-MMM-YYYYINV-001234โ€”InvoiceInitial milestone20,000.00โ€”20,000.00โ€”โ€”0.00
DD-MMM-YYYYPAY-000567UTR12345PaymentBank transferโ€”12,000.008,000.00โ€”โ€”0.00
DD-MMM-YYYYCN-000045โ€”Credit NoteScope adjustmentโ€”5,000.003,000.00โ€”โ€”0.00
DD-MMM-YYYYREF-000078NEFT678RefundRefund of CN-000045โ€”โ€”3,000.001,500.00โ€”0.00
DD-MMM-YYYYPAY-000088UTR99PaymentAdvance receiptโ€”โ€”3,000.00โ€”10,000.0010,000.00
DD-MMM-YYYYINV-001245โ€”InvoiceMaintenance8,000.00โ€”11,000.0010,000.00โ€”0.00

Notes:

  • Debit (Outstanding Table): amount billed (Invoices).
  • Credit (Outstanding Table): amount that reduces what’s owed (Payments, applied Credit Notes).
  • Outstanding: remaining receivable on the project after each entry.
  • Cash Balance Table: tracks advance / unapplied credit available at the project level โ€” it can be applied against future invoices on the same project, or refunded.
  • Cancelled invoices & cancelled credit notes are excluded from both Outstanding and Cash Balance running totals.
  • The dual-ledger structure mirrors the same logic used in the Client Ledger.

โœ… Use Cases

  • Monitor project-level financial health at a glance.
  • Share the statement with the client as the official project account report โ€” print a branded PDF directly from the tab.
  • Track collection status per invoice on this project.
  • Audit payments, credit notes, refunds, and manual adjustments before financial close.
  • Quickly identify overdue amounts on the project using the Invoices section’s Due Status column.

๐Ÿ’ก Tips

  • Always ensure Credit Notes are linked to the correct invoices โ€” this keeps the Outstanding column accurate at the project level.
  • Use the Ledger section to troubleshoot mismatches in amounts; the dual Outstanding / Cash Balance view makes it easy to see where an advance was used.
  • Before issuing a refund, verify that the corresponding Credit Note is issued and active โ€” refund cannot exceed the Credit column on that note.
  • Print the project statement at major billing milestones (proforma โ†’ invoice conversions, month-end, project close-out) and save it alongside client communication for a clean audit trail.
  • Need the consolidated view across all a client’s projects (including any direct Client Invoices)? Use the Client Statement tab on the client record instead โ€” it rolls up every project for that client and adds a per-project summary table.

How can we help?