API health
Live
Database ok
Backend-connected ERP
API Workbench
Live from NestJS, PostgreSQL, Prisma, Redis, and BullMQ
Work here now: create records, post journals, sync Tally, and run backend APIs.
This is no longer a static dashboard. Forms in each workspace call the deployed backend and the response panel shows the exact API response.
Checked 18 May 2026, 6:57 pmTenant 65945b07-bf9a-4120-8d2f-c0e1db14a341
API routes
114
Discovered from Swagger
Tally connections
1
3 sync runs
Trial balance
Balanced
2026-05-18
Accounts
19
19 chart accounts
Journals
9
9 journal rows
Invoices
0
0 invoice rows
Total debit
₹4,777.23
From PostgreSQL ledger rows
Total credit
₹4,777.23
From PostgreSQL ledger rows
Available backend modules
Authentication
17/api/v1/auth/csrf
/api/v1/auth/email-verification/confirm
/api/v1/auth/email-verification/request
/api/v1/auth/login
Accounting + Ledger
29/api/v1/accounting/accounts
/api/v1/accounting/accounts/categories
/api/v1/accounting/accounts/defaults
/api/v1/accounting/accounts/tree
Tally Integration
9/api/v1/tally/connections
/api/v1/tally/connections/{id}
/api/v1/tally/connections/{id}/test
/api/v1/tally/imports/ledgers
GST
13/api/v1/gst/adjustments
/api/v1/gst/analytics
/api/v1/gst/calculate
/api/v1/gst/compliance-documents/{id}/retry
Invoices
11/api/v1/invoices
/api/v1/invoices/customers/statement
/api/v1/invoices/numbering/next
/api/v1/invoices/recurring
Banking
6/api/v1/banking/accounts
/api/v1/banking/accounts/{id}/reconciliation/suggest
/api/v1/banking/accounts/{id}/statements/import
/api/v1/banking/accounts/{id}/transactions
Audit + Events
8/api/v1/audit/export
/api/v1/audit/integrity/hash-chain
/api/v1/audit/logs
/api/v1/audit/logs/{id}
Queues + Security
4/api/v1/queues
/api/v1/queues/monitor
/api/v1/security/events
/api/v1/security/policies
Accounting operations
Create accounts, post balanced journals, inspect ledgers, and verify financial reports.
Balanced journal posting
The form refuses to post unless debit equals credit.
Debit ₹100.00 / Credit ₹100.00
Chart of accounts
| code | name | type | normalBalance | isLocked |
|---|---|---|---|---|
| 1000 | Cash and Bank | ASSET | DEBIT | |
| 1100 | Accounts Receivable | ASSET | DEBIT | |
| 2000 | Accounts Payable | LIABILITY | CREDIT | |
| 2200 | Output CGST Payable | LIABILITY | CREDIT | |
| 2210 | Output SGST Payable | LIABILITY | CREDIT | |
| 2220 | Output IGST Payable | LIABILITY | CREDIT | |
| 2230 | Output Cess Payable | LIABILITY | CREDIT | |
| 3000 | Owner Equity | EQUITY | CREDIT | |
| 4000 | Sales Revenue | REVENUE | CREDIT | |
| 5000 | Operating Expenses | EXPENSE | DEBIT | |
| JRV183407A | Temporary Reversal Asset | ASSET | DEBIT | |
| JRV183407R | Temporary Reversal Revenue | REVENUE | CREDIT | |
| TLY-546DD029A8 | Enterprise Customer | ASSET | DEBIT | |
| TST182132 | Temporary COA Verification | ASSET | DEBIT | |
| UI145695 | Frontend Created Account | EXPENSE | DEBIT | |
| UI163649 | UI Workflow Test 163649 | ASSET | DEBIT | |
| UI935315 | Frontend Created Account | ASSET | DEBIT | |
| UIREV170811 | Revenue Account API Verify | REVENUE | CREDIT | |
| UIREV171027 | Revenue Account Verify After Fix | REVENUE | CREDIT |
Trial balance and ledger drill-down
| code | name | type | debit | credit |
|---|---|---|---|---|
| 1000 | Cash and Bank | ASSET | 236.00 | 0.00 |
| 1100 | Accounts Receivable | ASSET | 3361.23 | 0.00 |
| 2000 | Accounts Payable | LIABILITY | 0.00 | 0.00 |
| 2200 | Output CGST Payable | LIABILITY | 0.00 | 0.00 |
| 2210 | Output SGST Payable | LIABILITY | 0.00 | 0.00 |
| 2220 | Output IGST Payable | LIABILITY | 0.00 | 540.00 |
| 2230 | Output Cess Payable | LIABILITY | 0.00 | 0.00 |
| 3000 | Owner Equity | EQUITY | 0.00 | 0.00 |
| 4000 | Sales Revenue | REVENUE | 0.00 | 4237.23 |
| 5000 | Operating Expenses | EXPENSE | 0.00 | 0.00 |
| JRV183407A | Temporary Reversal Asset | ASSET | 0.00 | 0.00 |
| JRV183407R | Temporary Reversal Revenue | REVENUE | 0.00 | 0.00 |
| TLY-546DD029A8 | Enterprise Customer | ASSET | 1180.00 | 0.00 |
| TST182132 | Temporary COA Verification | ASSET | 0.00 | 0.00 |
| UI145695 | Frontend Created Account | EXPENSE | 0.00 | 0.00 |
| UI163649 | UI Workflow Test 163649 | ASSET | 0.00 | 0.00 |
| UI935315 | Frontend Created Account | ASSET | 0.00 | 0.00 |
| UIREV170811 | Revenue Account API Verify | REVENUE | 0.00 | 0.00 |
| UIREV171027 | Revenue Account Verify After Fix | REVENUE | 0.00 | 0.00 |
Invoice workflow
Create GST-computed draft invoices, issue, post, record payments, email, and generate PDFs.
Invoice actions
Invoices from backend
| invoiceNumber | customerName | status | totalAmount | balanceDue |
|---|---|---|---|---|
| No invoices returned. | ||||
GST operations
Validate GSTINs, calculate tax breakup, generate returns, and trigger compliance workflows.
GST backend summaries
Analytics
{
"period": "2026-05",
"generatedAt": "2026-05-18T13:27:02.223Z",
"byState": [
{
"stateCode": "27",
"taxableValue": "2000.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "360.00",
"cess": "0.00",
"invoiceValue": "2360.00"
}
],
"byHsn": [
{
"hsnSac": "9983",
"taxableValue": "2000.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "360.00",
"cess": "0.00",
"invoiceValue": "2360.00"
}
]
}Reconciliation
{
"period": "2026-05",
"generatedAt": "2026-05-18T13:27:02.229Z",
"totalInvoices": 2,
"missingEinvoices": 1,
"missingEWayBills": 1,
"rows": [
{
"invoiceId": "20d43308-432d-4ac0-a269-616cc92b15c1",
"invoiceNumber": "INV-LIVE-1778997472673",
"invoiceDate": "2026-05-17",
"customerGstin": "27ABCDE1234F1Z5",
"taxableValue": "1000.00",
"taxTotal": "180.00",
"einvoiceStatus": "MISSING",
"ewayBillStatus": "MISSING"
},
{
"invoiceId": "1e5740be-298f-4a4e-8322-47e174f45204",
"invoiceNumber": "INV-20260518112148-7XR2M7",
"invoiceDate": "2026-05-18",
"customerGstin": null,
"taxableValue": "1000.00",
"taxTotal": "180.00",
"einvoiceStatus": "GENERATED",
"ewayBillStatus": "GENERATED"
}
]
}GSTR-1
{
"period": "2026-05",
"generatedAt": "2026-05-18T13:27:02.230Z",
"b2b": [
{
"invoiceId": "20d43308-432d-4ac0-a269-616cc92b15c1",
"invoiceNumber": "INV-LIVE-1778997472673",
"invoiceDate": "2026-05-17",
"type": "SALES",
"customerGstin": "27ABCDE1234F1Z5",
"customerName": "Acme India Pvt Ltd",
"taxableValue": "1000.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "180.00",
"cess": "0.00",
"invoiceValue": "1180.00"
}
],
"b2c": [
{
"stateCode": "27",
"taxableValue": "1000.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "180.00",
"cess": "0.00",
"invoiceValue": "1180.00"
}
],
"hsnSummary": [
{
"hsnSac": "9983",
"taxableValue": "2000.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "360.00",
"cess": "0.00",
"invoiceValue": "2360.00"
}
],
"totals": {
"taxableValue": "2000.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "360.00",
"cess": "0.00",
"invoiceValue": "2360.00"
}
}GSTR-3B
{
"period": "2026-05",
"generatedAt": "2026-05-18T13:27:02.249Z",
"outwardSupplies": {
"taxableValue": "2000.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "360.00",
"cess": "0.00",
"invoiceValue": "2360.00"
},
"outwardAdjustments": {
"taxableValue": "0.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "0.00",
"cess": "0.00",
"invoiceValue": "0.00"
},
"inwardReverseCharge": {
"taxableValue": "0.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "0.00",
"cess": "0.00",
"invoiceValue": "0.00"
},
"eligibleItc": {
"taxableValue": "0.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "0.00",
"cess": "0.00",
"invoiceValue": "0.00"
},
"netTaxPayable": {
"taxableValue": "2000.00",
"cgst": "0.00",
"sgst": "0.00",
"igst": "360.00",
"cess": "0.00",
"invoiceValue": "2360.00"
}
}Banking and reconciliation
Create bank ledgers, import statement rows, detect duplicates, and run reconciliation suggestions.
Statement import
Bank accounts and suspicious transactions
| bankName | accountName | accountNumberMasked | currency |
|---|---|---|---|
| HDFC Bank | Workflow Current 165123 | XXXX165123 | INR |
| transactionDate | description | direction | amount | riskScore |
|---|---|---|---|---|
| No suspicious transactions returned. | ||||
Tally integration
Create connectors, queue sync runs, import XML, and reconcile vouchers.
Use http://10.66.0.2:9000 after the WireGuard tunnel is active on the Tally machine.
Sync and XML import
Tally records
| name | companyName | status | lastSyncAt |
|---|---|---|---|
| Smoke Tally 20260518133526 | Sigma Review Pvt Ltd | ACTIVE | 2026-05-18T08:05:27.422Z |
| resource | status | appliedItems | failedItems | completedAt |
|---|---|---|---|---|
| LEDGERS | QUEUED | 0 | 0 | |
| VOUCHERS | COMPLETED | 1 | 0 | 2026-05-18T08:05:27.419Z |
| LEDGERS | COMPLETED | 3 | 0 | 2026-05-18T08:05:27.067Z |
Organization workspace
Manage current organization profile, branches, departments, branding, and subscription linkage.
Organization data
Current organization
{
"id": "65945b07-bf9a-4120-8d2f-c0e1db14a341",
"name": "Sigma Review Pvt Ltd",
"slug": "sigma-review",
"gstin": "29ABCDE1234F1Z5",
"status": "ACTIVE",
"createdAt": "2026-05-17T05:09:45.319Z",
"updatedAt": "2026-05-17T05:09:45.319Z",
"deletedAt": null,
"deletedById": null,
"branding": {
"id": "daeb20dc-e40c-46e2-a8e3-9ab3e219bf89",
"organizationId": "65945b07-bf9a-4120-8d2f-c0e1db14a341",
"legalName": "Sigma Review Pvt Ltd",
"logoUrl": null,
"primaryColor": "#0F766E",
"accentColor": "#F59E0B",
"supportEmail": null,
"settings": {},
"createdAt": "2026-05-17T07:32:54.060Z",
"updatedAt": "2026-05-17T14:14:49.710Z"
},
"subscription": {
"id": "cc397c90-3a07-4ebb-a0db-16473ad4f252",
"organizationId": "65945b07-bf9a-4120-8d2f-c0e1db14a341",
"planCode": "starter",
"status": "TRIALING",
"billingProvider": null,
"billingCustomerId": null,
"billingSubscriptionId": null,
"currentPeriodStart": null,
"currentPeriodEnd": null,
"metadata": {},
"createdAt": "2026-05-17T07:32:54.060Z",
"updatedAt": "2026-05-17T07:32:54.060Z"
},
"branches": [
{
"id": "7c60c6a4-5786-4547-8838-f342d0062b21",
"organizationId": "65945b07-bf9a-4120-8d2f-c0e1db14a341",
"code": "MAIN",
"name": "Main Branch",
"gstin": "29ABCDE1234F1Z5",
"stateCode": "29",
"addressLine1": null,
"addressLine2": null,
"city": null,
"postalCode": null,
"country": "IN",
"status": "ACTIVE",
"isDefault": true,
"createdById": null,
"createdAt": "2026-05-17T07:32:54.060Z",
"updatedAt": "2026-05-17T14:14:49.701Z",
"deletedAt": null,
"deletedById": null
},
{
"id": "3def383d-63db-4319-94ba-dc4e7a1bd822",
"organizationId": "65945b07-bf9a-4120-8d2f-c0e1db14a341",
"code": "WF165123",
"name": "Workflow Branch 165123",
"gstin": "29ABCDE1234F1Z5",
"stateCode": "29",
"addressLine1": null,
"addressLine2": null,
"city": null,
"postalCode": null,
"country": "IN",
"status": "ACTIVE",
"isDefault": false,
"createdById": "99282bdf-2866-469c-ba41-302b19631c82",
"createdAt": "2026-05-18T11:22:02.846Z",
"updatedAt": "2026-05-18T11:22:02.846Z",
"deletedAt": null,
"deletedById": null
}
]
}Subscription
{
"id": "cc397c90-3a07-4ebb-a0db-16473ad4f252",
"organizationId": "65945b07-bf9a-4120-8d2f-c0e1db14a341",
"planCode": "starter",
"status": "TRIALING",
"billingProvider": null,
"billingCustomerId": null,
"billingSubscriptionId": null,
"currentPeriodStart": null,
"currentPeriodEnd": null,
"metadata": {},
"createdAt": "2026-05-17T07:32:54.060Z",
"updatedAt": "2026-05-17T07:32:54.060Z"
}| code | name | stateCode | status |
|---|---|---|---|
| MAIN | Main Branch | 29 | ACTIVE |
| WF165123 | Workflow Branch 165123 | 29 | ACTIVE |
| code | name | branchId | status |
|---|---|---|---|
| FD165123 | Workflow Finance 165123 | 3def383d-63db-4319-94ba-dc4e7a1bd822 | ACTIVE |
Users and RBAC
Create users, invite members, inspect roles, and assign RBAC through backend APIs.
Users, roles, and permissions
| name | roleCode | status | |
|---|---|---|---|
| admin@sigmareview.in | SigmaBooks Admin | ACTIVE | |
| workflow165123@sigmareview.in | Workflow User 165123 | ACTIVE |
| code | name | description |
|---|---|---|
| OWNER | Owner | |
| ADMIN | Administrator | |
| ACCOUNTANT | Accountant | |
| AUDITOR | Auditor | |
| VIEWER | Viewer |
Permissions
[
{
"code": "ACCOUNT_READ",
"name": "Read accounts",
"description": "View chart of accounts.",
"category": "accounting"
},
{
"code": "ACCOUNT_MANAGE",
"name": "Manage accounts",
"description": "Create and update chart of accounts.",
"category": "accounting"
},
{
"code": "JOURNAL_READ",
"name": "Read journals",
"description": "View journal entries.",
"category": "accounting"
},
{
"code": "JOURNAL_CREATE",
"name": "Create journals",
"description": "Create draft journal entries.",
"category": "accounting"
},
{
"code": "JOURNAL_POST",
"name": "Post journals",
"description": "Post balanced journals into the ledger.",
"category": "accounting"
},
{
"code": "LEDGER_READ",
"name": "Read ledger",
"description": "View general ledger entries.",
"category": "accounting"
},
{
"code": "AUDIT_READ",
"name": "Read audit logs",
"description": "View immutable audit activity.",
"category": "audit"
},
{
"code": "BANKING_READ",
"name": "Read banking",
"description": "Read banking",
"category": "banking"
},
{
"code": "BANKING_MANAGE",
"name": "Manage banking",
"description": "Manage banking",
"category": "banking"
},
{
"code": "GST_READ",
"name": "Read GST",
"description": "View GST returns and analytics.",
"category": "gst"
},
{
"code": "GST_MANAGE",
"name": "Manage GST",
"description": "Create, lock, and file GST return periods.",
"category": "gst"
},
{
"code": "USER_READ",
"name": "Read users",
"description": "View users and memberships.",
"category": "identity"
},
{
"code": "USER_CREATE",
"name": "Create users",
"description": "Invite or create organization users.",
"category": "identity"
},
{
"code": "USER_UPDATE",
"name": "Update users",
"description": "Update user profile, status, and membership details.",
"category": "identity"
},
{
"code": "USER_DISABLE",
"name": "Disable users",
"description": "Suspend user access to an organization.",
"category": "identity"
},
{
"code": "INVITATION_READ",
"name": "Read user invitations",
"description": "Read user invitations",
"category": "identity"
},
{
"code": "INVITATION_CREATE",
"name": "Create user invitations",
"description": "Create user invitations",
"category": "identity"
},
{
"code": "INVITATION_REVOKE",
"name": "Revoke user invitations",
"description": "Revoke user invitations",
"category": "identity"
},
{
"code": "TALLY_READ",
"name": "Read Tally integration",
"description": "Read Tally connections, mappings, sync runs, and reconciliation output",
"category": "integration"
},
{
"code": "TALLY_MANAGE",
"name": "Manage Tally integration",
"description": "Manage Tally connector configuration and execute Tally sync workflows",
"category": "integration"
},
{
"code": "INVOICE_READ",
"name": "Read invoices",
"description": "View invoice records.",
"category": "invoicing"
},
{
"code": "INVOICE_CREATE",
"name": "Create invoices",
"description": "Create draft invoices and invoice lines.",
"category": "invoicing"
},
{
"code": "INVOICE_ISSUE",
"name": "Issue invoices",
"description": "Issue invoices to customers.",
"category": "invoicing"
},
{
"code": "INVOICE_POST",
"name": "Post invoices",
"description": "Post invoices to accounting journals.",
"category": "invoicing"
},
{
"code": "ORGANIZATION_READ",
"name": "Read organizations",
"description": "View organization profile and settings.",
"category": "organization"
},
{
"code": "ORGANIZATION_UPDATE",
"name": "Update organizations",
"description": "Update organization profile and settings.",
"category": "organization"
},
{
"code": "BRANCH_READ",
"name": "Read branches",
"description": "Read branches",
"category": "organization"
},
{
"code": "BRANCH_MANAGE",
"name": "Manage branches",
"description": "Manage branches",
"category": "organization"
},
{
"code": "DEPARTMENT_READ",
"name": "Read departments",
"description": "Read departments",
"category": "organization"
},
{
"code": "DEPARTMENT_MANAGE",
"name": "Manage departments",
"description": "Manage departments",
"category": "organization"
},
{
"code": "QUEUE_READ",
"name": "Read queues",
"description": "Read queues",
"category": "platform"
},
{
"code": "EVENT_READ",
"name": "Read domain events",
"description": "Read domain events",
"category": "platform"
},
{
"code": "ROLE_READ",
"name": "Read roles",
"description": "View roles and permission assignments.",
"category": "rbac"
},
{
"code": "ROLE_MANAGE",
"name": "Manage roles",
"description": "Change role permission assignments and membership roles.",
"category": "rbac"
},
{
"code": "REPORT_READ",
"name": "Read reports",
"description": "View financial reports.",
"category": "reporting"
},
{
"code": "SECURITY_READ",
"name": "Read security events",
"description": "Read security events",
"category": "security"
},
{
"code": "SECURITY_MANAGE",
"name": "Manage security events",
"description": "Manage security events",
"category": "security"
}
]Audit and security
Review immutable audit records, domain events, queue state, security policies, and record security events.
Audit, events, queues, and policies
| eventType | actorUserId | entityType | createdAt |
|---|---|---|---|
| 2026-05-18T11:52:13.624Z | |||
| 2026-05-18T11:49:38.341Z | |||
| 2026-05-18T11:40:28.545Z | |||
| 2026-05-18T11:38:12.915Z | |||
| 2026-05-18T11:22:06.668Z | |||
| 2026-05-18T11:22:05.984Z | |||
| 2026-05-18T11:22:05.339Z | |||
| 2026-05-18T11:22:03.673Z | |||
| 2026-05-18T11:22:02.849Z | |||
| 2026-05-18T11:22:01.416Z | |||
| 2026-05-18T11:21:59.359Z | |||
| 2026-05-18T11:21:58.146Z | |||
| 2026-05-18T11:21:57.467Z | |||
| 2026-05-18T11:21:53.852Z | |||
| 2026-05-18T11:21:53.132Z | |||
| 2026-05-18T11:21:50.367Z | |||
| 2026-05-18T11:21:49.716Z | |||
| 2026-05-18T11:21:49.700Z | |||
| 2026-05-18T11:21:48.968Z | |||
| 2026-05-18T11:21:48.292Z |
| eventType | aggregateType | status | createdAt |
|---|---|---|---|
| bank_statement_import | PENDING | 2026-05-18T11:21:58.148Z | |
| gst_compliance_document | PENDING | 2026-05-18T11:21:53.849Z | |
| gst_compliance_document | PENDING | 2026-05-18T11:21:53.128Z | |
| invoice | PENDING | 2026-05-18T11:21:50.369Z | |
| invoice | PENDING | 2026-05-18T11:21:49.718Z | |
| invoice | PENDING | 2026-05-18T11:21:48.302Z | |
| tally_sync_run | PENDING | 2026-05-18T08:05:27.426Z | |
| journal_entry | PENDING | 2026-05-18T08:05:27.416Z | |
| tally_sync_run | PENDING | 2026-05-18T08:05:27.091Z |
Queue monitor
{
"generatedAt": "2026-05-18T13:27:02.313Z",
"queues": [
{
"name": "emails",
"counts": {
"waiting": 0,
"active": 0,
"completed": 0,
"failed": 0,
"delayed": 0,
"paused": 0
}
},
{
"name": "pdf-generation",
"counts": {
"waiting": 0,
"active": 0,
"completed": 1,
"failed": 0,
"delayed": 0,
"paused": 0
}
},
{
"name": "gst-processing",
"counts": {
"waiting": 0,
"active": 0,
"completed": 2,
"failed": 0,
"delayed": 0,
"paused": 0
}
},
{
"name": "notifications",
"counts": {
"waiting": 0,
"active": 0,
"completed": 0,
"failed": 0,
"delayed": 0,
"paused": 0
}
},
{
"name": "ai-tasks",
"counts": {
"waiting": 0,
"active": 0,
"completed": 0,
"failed": 0,
"delayed": 0,
"paused": 0
}
},
{
"name": "reports",
"counts": {
"waiting": 0,
"active": 0,
"completed": 0,
"failed": 0,
"delayed": 0,
"paused": 0
}
},
{
"name": "tally-sync",
"counts": {
"waiting": 1,
"active": 0,
"completed": 0,
"failed": 0,
"delayed": 0,
"paused": 0
}
}
],
"retryPolicy": {
"attempts": 3,
"backoff": "exponential",
"deadLetterStatus": "DEAD_LETTER"
}
}Security policies
{
"owaspAsvs": {
"authentication": "JWT access tokens, refresh rotation, MFA/TOTP, brute-force throttling",
"accessControl": "tenant header binding, membership checks, RBAC permission guard",
"validation": "DTO validation whitelist and forbidden non-whitelisted input",
"logging": "append-only audit logs with hash chaining"
},
"headers": {
"csp": "default-src 'self'; frame-ancestors 'none'",
"hsts": "enabled by helmet in production behind TLS",
"referrerPolicy": "no-referrer"
},
"secrets": {
"strategy": "environment-backed secret injection with Kubernetes Secret examples",
"rotation": "JWT and auth encryption keys are isolated by purpose"
},
"monitoringHooks": [
"security_events table",
"audit hash-chain verification",
"rate limit and RBAC denial surfaces"
]
}Backend API workbench
Every Swagger route is executable here through the same secure frontend proxy. Fill path parameters and JSON body, then execute.
141 backend routes available