Month note
📂
No reconciliation yet
Upload files and click Run Reconciliation. New uploads add to existing data.
| Date | GRV | Product Code | Device | IMEI / Serial | Cost | MSISDN | Deal Sheet | Claim Type | Additional Info | Till Date | Till Doc Nr | Selling Price | Credit Note # | Credit Amt | Credit Sheet | Extras | Difference | Reason |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TOTALS (filtered) | ||||||||||||||||||
📋
No unmatched IMEI Claimed rows
Rows whose IMEI is not on Serials Purchased appear here only.
| IMEI | MSISDN | Activation Date | Claim Type | Report Reason | Deal Sheet | Acc Description | Acc Serial | Acc Price |
|---|
💳
No unmatched Credit Notes
Credit rows whose MSISDN is not on the Recons sheet appear here only.
| IMEI | MSISDN | Credit Note # | Credit Amount | Date | Deal Sheet | Credit Sheet |
|---|
🖥️
No unmatched Till Audit rows
Till rows whose IMEI is not on Serials Purchased appear here only.
| IMEI | Date | Doc Nr | Description | Selling Price |
|---|
✓
No difference issues
Rows with difference below -R0.01 or above R100. Check resolved to track fixes.
| ✓ | Date | GRV | Product Code | Device | IMEI | Cost | MSISDN | Deal | Claim | Till Date | Sell Price | Credit # | Credit Amt | Credit Sheet | Extras | Difference | Reason |
|---|
✓
No duplicates
Duplicate IMEI (blue border) or MSISDN (amber border). Set a Reason to clear the warning.
| Date | GRV | Device | IMEI | MSISDN | Cost | Deal | Claim | Credit # | Credit Amt | Difference | Reason | Comments |
|---|
✅
No issues found
All reconciled records look clean.
| Issue | IMEI | Description | Invoice | Date |
|---|
Cloud data & store isolation
Recon data is saved to Firebase at stores/{store}/{year}/…. Your login sets the active store for this session only — the app cannot read or write another store's path. For a public-facing deployment later, upgrade to Firebase Custom Auth Tokens (requires a small Cloud Function backend) so Firestore rules enforce store access server-side.
Google Sheets Sync
Connect each store to a free Google Sheet for cloud backup. One-time setup. Google Cloud Console →
1
Create a project, enable Google Sheets API, create an OAuth 2.0 Client ID (Web Application). Add this page's URL as an authorised origin.
2
Create 3 Google Sheets (one per store). Copy each Sheet ID from the URL: docs.google.com/spreadsheets/d/[ID]/edit
3
Paste below and save. Credentials stay in your browser only.
Change Passwords
Passwords are hashed locally. Default password is chatz2024.
⚠ Clear Store Data
Permanently delete all saved recon rows and uploaded file data for this store. This cannot be undone.