Using #tags in Prosaic

Tags in Prosaic offer a powerful way to add flexibility to coding transactions, allowing you to create subcategories within existing account codes and/or tracking categories to compare across properties, business units, or cost centres, especially when exported to Excel or any other reporting system. This guide will show you how to use tags effectively.

1. Using Tags as Subcategories

Tags allow you to create subcategories within your chart of accounts, offering additional granularity when tracking transactions.

How to add subcategories with tags:

1. Open the cash book and locate transactions you want to categorise.
2. Select transactions and click "Add Tag".
3. Type a new tag name (e.g., Owner Funds Introduced or Spa Pool Repairs).
4. Apply tags individually or in bulk to multiple transactions.
5. Export the table to Excel to see the subcategories reflected in the data.

📌 Example: If you want to track repairs by type, you can tag all plumbing expenses as “Plumbing” while still keeping them under the “Repairs & Maintenance” account.

2. Using Tags as Tracking Categories

Tracking categories allow you to compare financial data across multiple properties, projects, or departments.

How to set track across categories using tags

1. Create tags based on what you want to compare (e.g., rental properties: Ōhakune, Māpua).
2. Select relevant transactions and assign tags accordingly.
3. Export your transactions and use pivot tables in Excel or Google Sheets to compare financials across different tags.

📌 Example: If you own two rental properties, you can tag expenses with property names and then run comparisons in a pivot table to see how each performs financially.

3. Using Tags for Both Subcategories & Tracking Categories

You can apply multiple tags to a single transaction to use both subcategories and tracking categories simultaneously.

How to use both together:

1. Assign multiple tags to transactions (e.g., Owner Funds Introduced + Nick for equity transactions).
2. Export your data using the All Claimed Transactions CSV.
3. In Excel or Google Sheets, split and concatenate tags into separate columns.
4. Use a pivot table to view financials by category, subcategory, and tracking category.

📌 Example: You can tag a maintenance expense both by type (e.g., Plumbing) and by property (e.g., Ōhakune) to analyze costs across both dimensions.

Next Steps

• Experiment with tagging in Prosaic to see how it enhances reporting.
• Use naming conventions for consistency (e.g., Property – Name or Expense Type – Detail).
• Future updates may include built-in filtering and comparison tools.

🚀 Start using tags today to gain deeper financial insights and improve your workflow!

Let me know if you'd like any tweaks! 🚀