Cambium Bills

bank charges → Propertyware upload  ·  bills.cambiumre.com
Bills Upload
CAM Reconciliation
  1. 1 · Run Summary — preview this month's charges, mapping results, and exceptions (changes nothing)
  2. 2 · Build Outputs — create the review/exception workbooks and the paste-ready data
  3. 3 · Copy data — click the green button in the results, then paste into cell A2 of a fresh Bills-Workbook and upload to Propertyware
  4. 4 · Close Out Month — after PW confirms the import, archive this month's inputs and outputs
Close Out shows a preview and asks before archiving — files are moved, never deleted. The Exceptions Dashboard is where unmatched charges get checked off as they're entered in PW by hand.
  1. 1 · Ingest Statements — parse the year's income-statement workbook(s) from CAM_Recon/INPUT into per-building totals
  2. 2 · Ingest Leases + 3 · Ingest Charges — pull the rent roll and billed CAM charges from Propertyware
  3. 4 · Preview — check the numbers and exceptions (writes nothing)
  4. 5 · Build Reports — write the recon workbook + a share-ready report per building to CAM_Recon/OUTPUT
Re-running any step replaces its files in place. Preview and Build compute identically — Build also writes the deliverables.

Results

Run a step above — results appear here.