CE Certificate System v14

📅 Date Filter

From Date

To Date

Total Certs

0

All time

This Month

0

Current month

This Year

0

FY 2025-26

Active CEs

0

Engineers

🧾 INVOICES

Total Invoiced

₹0

0 invoices

Total Received

₹0

0 paid

Balance Due

₹0

0 pending

Total GST

₹0

Collected

IGST

₹0

Interstate GST

CGST

₹0

Central GST

SGST

₹0

State GST

This Month

₹0

Billing

📈 Monthly Certificates

Last 6 months — certificates issued

✈ Mode Breakdown

AIR / SEA / ROAD / COURIER split

💰 Monthly Billing (₹)

Invoice amounts — last 6 months

📊 Invoice Status

Paid / Partial / Pending

Currency & Terms of Trade

Terms of Trade

A. Certificate Info

Cert. Ref. No.

Certificate Date

Chartered Engineer

Reg. No.

Institution

Condition

Type of Goods

Form of Goods in Report

Mode of Transport

B. Invoice & Goods

Invoice Type

Invoice No. & Date

CHA Name (Customs House Agent)

Supplier Name

Supplier Address

B.1 — Inspection

Location of Clearance (Major Customs)

Place of Inspection

Date of Inspection

Duration (Hours)

C. Importer Details

I Importer Name

II Address

III IEC Code No.

D. Additional Details

I BE No. & Date

II MAWB No. & Date

III HAWB No. & Date

IV Exchange Rate (1 USD = ₹ ?)

V No. of Pkgs.

VI Container No.

E. Necessary Additional Details

Electronic Waste

Gross Weight

Purpose of Utilization

Accessories

Catalogues / Documentation

Annexure Settings

Residual Life column in Annexure?

Notes & Partial Shipment — shown in Annexure

⚡ Auto-Generate Capital Goods Note

Notes Text (editable)

🚢 Partial Shipment?

F. Machine / Item Details

① How many line items?

item(s)

⚙ Field XIV — Dismantling / Packing Charges

Charges apply to

Are charges applicable?

→ Value in Section D Field XIV will be: "Not Available"

📜 Certificate Details

Total

0

All certificates

This Month

0

Current month

This Year

0

FY

Showing

0

Filtered results

Sr.	Report No.	Date	Mode	Importer	Place of Clearance	BE No.	CE Name	Items	Actions
No certificates yet.

User & CE Management

Add New CE / User

Full Name

Username

Password

Role

Registration No.

Institution

⚙ Report Number Settings

🛡 Supabase Cloud Backup Not Configured ↻

Advanced versioned cloud backup — encrypted Supabase key, PBKDF2 passwords, offline queue, conflict resolution, audit log, integrity checks.

Supabase Project URL

Anon Key (stored AES-encrypted)

Last Sync

Never

Queue

0

Integrity

—

Session

—

🔄 Multi-User Sync Not Configured

Connect to Firebase Realtime Database to share data across all users in real time. Free tier supports up to 100 concurrent users. Create a free Firebase project →

Firebase Project URL

Database Secret / Auth Token (optional — for private DB)

How to set up Firebase (free, 2 minutes):
1. Go to console.firebase.google.com → Create project → Realtime Database
2. In Database Rules, set ".read": true, ".write": true (for trusted office network)
3. Copy the Database URL (e.g. https://myproject-default-rtdb.firebaseio.com) and paste above
4. Click Save & Connect — all users open the same HTML file and data syncs automatically

💾 Backup, Export & Restore

📊 Export to Excel

Download all certificates and invoices as Excel workbooks.

🗄 JSON Backup & Restore

Full backup of all data including customers and settings.

💡 Recommended backup workflow: Export to Excel weekly for records. Download full JSON backup daily. If using Firebase, data is already synced — JSON backup is an additional safety net.

⚙ Report Number Settings

Customize Report Number Format

Preview: —

Prefix (e.g. VSJ, PER, ABC)

Middle Part (e.g. CEC/IMP)

Running Number Prefix (e.g. MOT, REP)

Number of Digits (e.g. 2 → 01, 3 → 001)

Include Mode (AIR/SEA/ROAD/COURIER)?

Include Financial Year?

Invoice Number Format

Preview: —

Prefix (e.g. VSJ, PER)

Middle (e.g. INV, BILL)

Number of Digits

Include Financial Year?

Format Style

📋 Default Terms & Conditions (auto-loaded & locked in every invoice — not editable on the invoice form)

Terms & Conditions Text

🏢 Firm Profile (used in all invoices)

No Logo

Company Logo

PNG/JPG — max 200×80px recommended

Firm / Company Name

Tagline / Designation

Address

GSTIN

PAN

SAC Code

Phone

Email

Website

Bank Details

Bank Name

Account No.

IFSC Code

Branch

Account Type

Company Seal & Signature

🔵 Company Seal

No Seal

PNG with transparent background recommended

✍ Authorised Signature

No Signature

PNG with transparent background recommended

📊 Self Appraisal Register

From Date

To Date

Loading...

Invoice Type

Invoice Details

Invoice No. (Auto-generated from Settings)

Invoice Date

Link to Certificate Report

Bill To (Client)

Select from Customer Directory

Company / Client Name

Address

GSTIN

State Code

State

PAN

Shipped To (if different from Bill To)

Same as Bill To

Service Items

Additional Notes (optional — for this invoice only)

📋 Terms & Conditions

🔒 Read-only Edit only in Settings → T&C

Invoice Preview Draft

📋 Saved Invoices

Invoice No.	Date	Client	Cert. Ref	Type	Amount (₹)	Paid (₹)	Balance (₹)	Status	Actions
No invoices saved yet.

👥 Customer Directory

Add / Update Customer

Company Name *

Contact Person

Phone

Email

PAN

IEC Code

🏢 GST Registrations

No GST registrations added yet. Click + Add GST to begin.

Company Name	Contact	Phone	Email	GST Registrations	Actions
No customers yet.

📒 Account Ledger

Client

Status

From Date

To Date

💰 Expenses

➕ Add Expense

Date

Sr.	Date	Category	Description	Mode	Ref No.	Amount (₹)	Actions
No expenses yet. Add your first expense above.

🧮 GST Report

Financial Year

Month

GST Type

Total Invoiced

₹0

Taxable value

Total GST

₹0

CGST + SGST + IGST

CGST

₹0

0 invoices

SGST

₹0

0 invoices

IGST

₹0

0 invoices

SEZ / LUT

₹0

0 invoices

#	Invoice No.	Date	Client	GSTIN	Taxable (₹)	GST Rate	CGST (₹)	SGST (₹)	IGST (₹)	Total (₹)	Type
Click Generate to build report

🤖

AI Assistant — CE System

Ask anything about certificates, customs, reconditioning fields, or your data

🔑 Anthropic API Key: Key stored locally. Get yours at console.anthropic.com

AI

👋 Hello! I'm your CE Certificate Assistant.

I can help you with:

• Filling in certificate fields (IX–XIII, reconditioning details)
• Customs regulations & Circular 07/2020
• Invoice & GST questions
• Summarising your certificate/invoice data

Add your Anthropic API key above to get started, then type your question below.

Download

📈 Monthly Certificates

✈ Mode Breakdown

💰 Monthly Billing (₹)

📊 Invoice Status

📜 Certificate Details

User & CE Management

Add New CE / User

⚙ Report Number Settings

🛡 Supabase Cloud Backup Not Configured ↻

Sync Conflict Detected

🔄 Multi-User Sync Not Configured

💾 Backup, Export & Restore

⚙ Report Number Settings

Customize Report Number Format

Invoice Number Format

📋 Default Terms & Conditions (auto-loaded & locked in every invoice — not editable on the invoice form)

🏢 Firm Profile (used in all invoices)

📊 Self Appraisal Register

📋 Saved Invoices

👥 Customer Directory

Add / Update Customer

📒 Account Ledger

💰 Expenses

🧮 GST Report

AI Assistant — CE System

💳 Record Payment

🚢 Sea Shipment Details

Edit User

💱 Exchange Rate