These are your VAT invoice entries. Click Invoice ✗ to confirm payment was allocated to the invoice (creates audit trail).
Click Statement ✗ to link bank statement showing payment was received.
Click ✓ indicators to view details or reverse confirmation.
Loading entries...
These are incoming payments from your bank statements that need VAT invoice entries created.
Click CREATE VAT to link them to your VAT records.
Loading bank payments...
UPLOAD DATA FILES
×
Select the type of data you want to upload:
Bank Statements (CSV)
Upload CSV files from Nedbank or Investec Private Bank
Default: C:\MXPRO\BANK_DOCS\{entity}
Invoice Data (XLSX)
Upload Excel files with invoice/expense data
Default: C:\MXPRO\INVOICE-XLSX
IMPORT FROM LEGACY SYSTEM (Excel)
×
Import invoice data from legacy Excel files (V_PRC, V_TEN, etc.)
Default location: C:\MXPRO\INVOICE-XLSX
Import Results
0
Complete
0
Incomplete
0
Skipped
INCOMPLETE RECORDS - Review & Fix
×
These records were imported but are missing required data. Click a row to edit.
Instructions (as per SARS VAT201):
- OUTPUT GROSS: Enter total sales/income (VAT inclusive). Output VAT calculated as 15/115.
- INPUT VAT: Enter the actual VAT amount claimed on purchases.
Period
Output GROSS
Output VAT
Input VAT
NET VAT
Status
Select an entity and click LOAD PERIODS to begin
Total Output VAT
R 0.00
Total Input VAT
R 0.00
Total Net VAT
R 0.00
Periods Entered
0 / 0
LIVE PREDICTIONS (Based on entered data)
PERIOD 202512 (Dec 2025)
Output GROSS:
R 0.00
Output VAT:
R 0.00
Input VAT:
R 0.00
PREDICTED NET VAT
R 0.00
PERIOD 202510 (Oct 2025)
Output GROSS:
R 0.00
Output VAT:
R 0.00
Input VAT:
R 0.00
PREDICTED NET VAT
R 0.00
Predictions use Year-over-Year method with 5% growth adjustment
Trial Balance — VAT correlation uses NVP only (practice income). Tax year: Mar-Feb. EVEN cycle: Apr,Jun,Aug,Oct,Dec,Feb.
Select an entity and click LOAD TB
VAT201 DATA STATUS — Fill missing periods for accurate TB predictions
Import Trial Balance Data
INCOME (CR)
EXPENSES (DB)
TAXES PAID (DB)
LOAN BALANCE
LNSLOANS (CR)LNSLOANS (DB)
Timestamp
User
Action
Description
IP Address
Loading audit log...
✎ EDIT VENDOR
✎ EDIT USER
Change Password (Optional)
Leave both blank to keep current password
+ ADD ENTITY
SARS assigns entities to ODD or EVEN month VAT return cycles
✎ EDIT ENTITY
SARS assigns entities to ODD or EVEN month VAT return cycles
📦 Delivery & Contact Info
Used in order emails and QR codes for vendors
Comma-separated email addresses to CC on orders
Latitude, Longitude - for QR code delivery location
+ ADD NEW USER
+ ADD NEW CATEGORY
⚠️ SA Tax Compliance: Entity-prefixed categories are ring-fenced for separate tax reporting
Select a parent for sub-categories
GENERAL = Fuel, Salaries, Rent | CAPITAL = Vehicles, Equipment, Buildings
✎ EDIT CATEGORY
Category code cannot be changed
Category type cannot be changed
Select a parent for sub-categories
GENERAL = Fuel, Salaries, Rent | CAPITAL = Vehicles, Equipment, Buildings
BOOKKEEPING
REPORTS
VAT SUMMARY
Select a period above
OUTPUT VAT
R 0.00
INPUT VAT
R 0.00
VAT DUE TO SARS
R 0.00
BANK STATEMENT IMPORT & CATEGORIZATION
IMPORT CSV
VERIFICATION QUEUE
CATEGORIZATION RULES
IMPORT HISTORY
Upload Bank Statement CSV
Review Pending Transactions
AI Categorization Rules
Import History
VERIFY TRANSACTION
Categorization
Correct the vendor name if needed
INCOME/EXPENSE REPORTS
Generate categorized income and expense reports from verified bank transactions.
Generating report...
Please wait while we generate your PDF report.
VAT201 REPORT GENERATOR
Report Parameters
Entity
Period
TRANSACTION VERIFICATION
Review and fix all validation errors before filing the period
All Transactions
PERIOD FILED SUCCESSFULLY
Review scenarios and generate VAT201 documents
4-SCENARIO ANALYSIS
RECURRING TRANSACTION ANALYSIS
🔧 QUICK FIX TRANSACTION
CREATE VAT ENTRY FROM BANK STATEMENT
VAT Transaction Details
Leave empty to use bank statement description
⚠ VAT CALCULATION OVERRIDE
For grouped payments, enter the actual VAT amount. Leave empty for standard 15% calculation.
💡 Example: For "PAYMENTS RECEIVED R 5428.78" representing multiple patient bills, enter the actual VAT portion (e.g., R 707.18) here.
💰 UNMATCHED BANK PAYMENTS
These are incoming payments from your bank statement that need VAT invoice entries created. Click CREATE VAT to match them.
📦 INVOICE ITEMS - Add Delivery Items
Vendor
-
Invoice #
-
Invoice Total (incl VAT) ✎ editable
R
Destination
Line item prices are:
Line Items
Description
Category
Destination
Qty
Unit
Unit Price
Line Total
Action
Items Subtotal (excl VAT):R0.00
VAT @ 15%:R0.00
Items Total (incl VAT):R0.00
Invoice Total:R0.00
Difference:R0.00
-
⛽ Fuel Purchase Details
📦INVENTORY - All Invoice Items
0 items
Loading inventory items...
🏷️CATEGORY MANAGEMENT
Add New Category
Existing Categories
Click on a category to rename it. Categories with items show item count.
Edit Inventory Category×
➕ Add New Category×
Enter the new category name. It will be added to the database and selected automatically.