💳 AP Lookup

Look up CW1 charge line status before uploading AP costs.

	Input				Charge Code						Job

Charge Code columns

AccrualCharge cost amount — AP invoice not yet allocated in CW1

VarianceJob Accrual − Cost To Upload

CostCharge cost amount — AP invoice allocated

RevCharge sell amount — AR invoice raised in CW1

MarginRev − |Cost| − Cost To Upload

% MarginMargin ÷ Rev (blank if Rev = 0)

Job columns

RevTotal job revenue — AR invoices raised

CostTotal job cost — AP allocated (shown negative)

Margin ActualJob Rev − |Job Cost|

Margin Actual %Margin Actual ÷ Job Rev

WIPTotal job sell — AR not yet raised

AccrualTotal job cost — AP not yet allocated

Job MarginMargin Actual + WIP − Accrual

Job Margin %Job Margin ÷ (WIP + Rev)