When you decide a category belongs in records rather than a spreadsheet, here is the metadata you capture per item. A spreadsheet can hold the text values; what it cannot do is keep the actual document attached to the same entry or carry a real status. These are the fields a single invoice or expense record uses in Cash Workspace.
- Counterparty
- The client, vendor, or supplier name (e.g. 'Riverside Cafe' or 'Office Depot'). This is what you scan and group by, just like a spreadsheet column — but here it keys a full record.
- Amount
- The invoice or expense amount, as a plain number you type in. No calculation or extraction happens; you enter what the document says.
- Date
- Invoice date, payment date, or receipt date depending on the record type — the date you would have put in a spreadsheet cell.
- Status
- A real status the record carries, such as Sent, Partially paid, or Paid for invoices, or Received, Due, Paid for bills. Unlike a 'Paid?' cell, it belongs to the record itself and you update it as the item progresses.
- Category
- A product-defined expense category (for example Software, Travel, Supplies) you pick from the workspace, so similar expenses group consistently across the year.
- Attached document
- The actual receipt, invoice PDF, or statement attached directly to this record. This is the core thing a spreadsheet cell cannot do — the number and its proof live together. You attach the file yourself; nothing is read or auto-classified.
- Note
- A free-text note for context a spreadsheet column rarely captures — 'split with the May invoice,' 'client disputed line 3,' 'reimbursed personally.'