1. Login with the Gmail account that owns the Google Drive where the working files must be stored.
2. Open Settings and click Edit.
3. Fill Firm Name, GST Number, Mobile Number, report email IDs, invoice prefix, ARN, credit note prefix, credit note starting number, signatory name, firm/company name, designation, and address details.
4. Do not manually change Google Sheet ID or generated folder IDs unless support asks you to do it. These are created and saved by the app.
5. Click Save.
6. Click Authorize Drive and complete Google permission for Drive, Sheets and Gmail actions.
7. Click Create / Verify Folder Structure. This creates the required Source, Working, Final, Consolidated, Backup and Old Invoice folders inside your Master Folder.
8. Click Create Working Sheet From Master. This creates your working Google Sheet from the Advisor Tech Hub master template.
9. Click Edit again, upload Sign and Seal, then click Save or the individual Upload buttons. The sign and seal are placed permanently inside both invoice templates.
10. Click Check & Sync Templates. After this, invoice processing can be started.

1. Open Invoice Processing.
2. Upload CAMS PDF files in CAMS PDFs.
3. Upload KFIN ZIP/PDF files in KFIN ZIP/PDF.
4. Click Start Complete Process.
5. The app extracts KFIN files, parses CAMS and KFIN invoices, prepares DFIS, and then pauses at Manual Invoice Insertion.
6. If there are no manual invoices, click Continue.
7. If manual invoices are required, select AMC Master or Vendor Master, select the company, enter invoice date and taxable amount, add more rows if needed, then click Continue.
8. The app sorts all rows by date, updates RTA, generates invoice numbers, creates invoice PDFs, prepares CAMS/KFIN upload Excel files, sends the email, moves DFIS to Consolidated, and archives files.
9. For a usual monthly batch, the practical end-to-end processing time is normally within 15 to 20 minutes depending on invoice count and Google export speed.

Use Complete Process without Manual Insertion when no manual invoices are required. Use Process Invoice with Manual Insertion when Corporate FD, P2P, ND, or other manual invoices must be inserted before invoice numbering.

The manual invoice pause is only for inserting additional invoice rows before invoice numbering. Use it when you have Corporate FD, P2P, ND, or any other manual invoice to include in the same monthly sequence.

1. Select Source as AMC Master if the invoice is for an AMC-related entity.
2. Select Source as Vendor Master if it is P2P, Corporate FD, ND, Rental-related, or another vendor-type invoice.
3. Select the company from dropdown. Hidden GST, address, state and tax fields are fetched from the master data.
4. Enter only the required business fields such as invoice date, taxable amount, product/description and invoice serial number where applicable.
5. Click Add Manual Row if multiple invoices must be inserted.
6. If no manual invoice is needed, leave the row blank and click Continue.
7. After Continue, the process resumes automatically. Do not click Start Complete Process again for the same batch.

A fresh user gets 1 complete invoice-processing run or 20 days, whichever comes first. Only invoice generation is available during trial, and only Start Complete Process consumes the trial run. Bank reconciliation and GST report export require an active paid subscription. From July 10 onward, Plus Annual is Rs. 999/year with 120 invoices and Pro Annual is Rs. 2499/year with unlimited invoices. Paid validity is 1 year from payment.

Advisor Tech Hub uses annual Razorpay Payment Links, not auto-debit subscriptions. Save Razorpay Key ID, Plus amount, Pro amount, Plus invoice limit, payment link expiry days, mode, and optional fallback links in Admin Settings. Store Razorpay Key Secret only in Firebase Secret Manager as RAZORPAY_KEY_SECRET. When a user clicks Pay Plus, Pay Pro, Renew, or Upgrade, Firebase creates a fresh user-specific payment link with the current admin amount. Same-plan renewal opens only during the final 30 days of the active annual package. Razorpay webhook updates the user account after successful payment.

In Firebase, set RAZORPAY_KEY_SECRET using the Razorpay test key secret. In Admin Settings, save Razorpay Mode as TEST, paste Razorpay Key ID, enter Plus amount, Pro amount, Plus invoice limit, and payment link expiry days. Login as a trial user and test Pay Plus and Pay Pro. After testing, repeat the same key setup in Live Mode. Future price changes require only Admin Settings amount changes; new payment links will use the updated amount.

Before deploying webhook automation, set Firebase secrets named RAZORPAY_WEBHOOK_SECRET and RAZORPAY_KEY_SECRET. After deploy, copy the Razorpay Webhook URL from Admin Settings into Razorpay Dashboard. Enable payment.captured, payment.failed, payment_link.paid, and payment_link.cancelled. The preferred flow is the Pay Plus / Pay Pro button inside the app, because Firebase creates a fresh Razorpay link with the user's UID, email, plan and GST details in the link notes. This lets the webhook match the payment to the exact user. Static fallback Payment Page links are only a backup; for those, the user must enter the same registered email or mobile number because Razorpay will not automatically send the Firebase user ID.

After Razorpay confirms payment, Advisor Tech Hub sends a payment receipt email to the customer with a PDF attachment. Since Advisor Tech Hub is currently not issuing GST tax invoices for the software package, this document is named Payment Receipt / Subscription Receipt and does not show GST breakup. To enable this mail, set Firebase secrets RECEIPT_SMTP_USER and RECEIPT_SMTP_PASS with the sender Gmail ID and app password. Payment Receipt BCC Email in Admin Settings can be used to keep an internal copy.

Settings are split into top tabs so you can complete one area at a time. Click Edit, unlock only the field that must be changed, update it, and click Done. The field is saved immediately. When you move to another Settings tab, open edits are auto-saved. Firm Name, GST Number, PAN, address lines, city with pincode, state, place of supply, state code, ARN, invoice prefix or invoice number format, mail IDs, auditor mail IDs, signatory name, company name, designation, Google Sheet ID, and Master Folder ID should be saved before processing. GST Number auto-fills PAN and state details when valid. Mail CC and BCC can contain multiple email IDs separated by comma.

Use {SEQ} wherever the running number should appear. Invoice Sequence Digits controls whether the number appears as 01, 001, 0001 and so on. Existing users can continue using Invoice Prefix without changing anything.

• GO/FY26-27/{SEQ} generates GO/FY26-27/001.
• {SEQ}\2026-27 generates 001\2026-27.
• {SEQ}/2026-27 generates 001/2026-27.
• WC/2026-27/{SEQ} generates WC/2026-27/001.

Credit Note Number Format also supports {SEQ}. If no credit note format is entered, the app continues with Credit Note Prefix plus the running number.

• GO/FY26-27/CN/{SEQ} generates GO/FY26-27/CN/001.
• CN/{SEQ}\2026-27 generates CN/001\2026-27.
• {SEQ}/CN/2026-27 generates 001/CN/2026-27.

Upload Sign and Seal from Settings. Sign is expected as 225 x 75 px and Seal as 175 x 175 px. After choosing the file, click Upload Sign or Upload Seal, or save the Settings after selecting the files. The file name appears below the input. The images are stored once and then placed permanently inside InvoiceTemplate and ManualInvTemplate. After every template sync, the app places the saved sign and seal again in both templates. Invoice generation and PDF export will not paste or clear these images row by row.

This button creates the Source, Working, Final, Consolidated, Backup, and Old Invoice folders under the client's Master Folder ID. It also saves all generated folder IDs in the client's settings. If the button says the folder is not accessible, check that the logged-in Gmail owns or has access to that Drive folder and that Google Drive API is enabled.

The admin controls the master working Google Sheet and GST report template. First-time client setup copies the complete master working sheet with formatting. Later sync updates standard upload templates from the master source while preserving client data. AMC Master and Vendor Master are appended with missing master rows instead of replacing the client's edited rows.

In Settings or Admin, select an AMC from the dropdown. Existing data is displayed in locked fields. Click Edit Details to unlock, modify the fields, then Save AMC or Save Master AMC. If Add New AMC is selected, fields remain editable. GSTIN auto-fills PAN and state code. State dropdown also updates Name of State and Place of Supply.

Use Vendor Master for P2P, Corporate FD, Rental, and other manual invoice vendors. Select a vendor from the dropdown to view locked details. Click Edit Details to change it. Save Vendor updates the existing VendorMaster row if the same GSTIN or company/product combination is found; otherwise it adds a new row.

Admin login shows only admin-oriented menus. Admin can view users, monitor complete invoice run counts, set the master working sheet ID, set the GST report template ID, add/edit Master AMC records, add/edit Master Vendor records, and allow specific users to use custom template field mapping. Normal user processing tabs are hidden for admin login. When admin changes user subscription status, extends validity, enables/disables custom template mapping, or corrects protected GST/ARN details, the app records the action and sends a professional confirmation email to the customer where email settings are available.

Complete Process without Manual Insertion checks templates, extracts files, parses invoices, skips the manual pause, sorts DFIS, updates RTA, generates invoice numbers, creates invoice PDFs, exports CAMS/KFIN upload files, sends mail, moves DFIS to consolidated data, and archives generated files. Process Invoice with Manual Insertion performs the same flow but pauses after parsing so manual invoice rows can be inserted before sorting and numbering. Continue is used only after the manual invoice insertion point. Pause / Resume continues longer PDF/export processing from DFIS. Stop / End is for ending the current screen session. Reset & Clear Screen clears the UI, parsed-file memory, and invoice source/final generated files from Drive trash-safe folders.

When the process pauses, add manual rows if needed. Use AMC Master for AMC-related rows and Vendor Master for P2P, Corporate FD, Rental, or other products. You can also open the DFIS Google Sheet link for direct review. Enter only invoice date, taxable amount, reference number, description, and optional manual invoice number. If Manual Invoice Number is blank, the normal broker invoice sequence is generated after sorting. If you type a Manual Invoice Number, that number is used only for that manual row and is not forced into the regular sequence. After saving each row, check the summary line before clicking Continue.

Choose Continue from Consolidated Sheet to continue from the latest invoice number already stored in Consolidated. Choose Enter Starting Number only when you intentionally want to start from a specific number. Two digit numbers are padded with zero where applicable, and three digit numbers are kept as entered. Manual invoices and parsed AMC invoices share the same sorted sequence.

Upload CAMS PDFs in the CAMS upload box and KFIN ZIP/PDF files in the KFIN box. Bank statement upload is available only in Bank Reconciliation. Uploaded source files are stored in the client's Drive source folders. During processing, Live Activity shows extraction, parsing, row creation, PDF export, upload export, mail, and cleanup status.

Open Credit Notes, click Load AMC / Invoices, select AMC, pick the original invoice, enter the AMC credit note number, confirm or edit the user credit note number, enter taxable credit value, tax mode, SAC, and description, then Generate Credit Notes. Generated details are stored in ConsolidatedCreditNote and used in GSTR/GST report export.

1. Open Bank Reconciliation.
2. Upload your bank statement in Excel or CSV format.
3. Click Upload.
4. Click Run Reconciliation.
5. The app reads credits and compares invoice totals, taxable value, GST value, current month receipts, previous month receipts, and pending credits based on Consolidated invoice data.
6. Within a few minutes, the reconciliation summary appears on screen and the detailed report is mailed.
7. After successful reconciliation and mail, the uploaded bank source file is moved to trash automatically. Extra unrelated bank credits are not included in the mailed report.

1. Open GST Report Exports.
2. Select the month for which the GST report is required.
3. Click Generate GST Report.
4. Sales data comes from Consolidated, manual invoice GSTIN/state data comes from VendorMaster when the source is Manual, and credit notes come from ConsolidatedCreditNote.
5. The main GSTR-1 Excel includes B2B invoice rows in b2b,sez,de and credit notes in cdnr. Amendment sheets are maintained in the template but left blank unless future amended invoice support is enabled.
6. The app also generates a GSTR-1 JSON file with top-level GSTIN from the user's saved GST number, filing period, B2B invoices, and CDNR credit notes where available.
7. Rental RCM is not inserted inside the main GSTR-1 workbook. If Rental RCM is enabled, it is generated as a separate RCM Excel file and attached separately.
8. The GSTR-1 Excel, GSTR-1 JSON, and separate RCM Excel if applicable are shown for download and mailed to the configured auditor/report email IDs in HTML format.

Rental RCM is optional and hidden by default. To use it, open Settings, enable Show Rental RCM Tab, and save the field. Rental RCM is for rent payments where reverse charge reporting is applicable. Confirm applicability with your auditor before using it.

1. Open Rental RCM.
2. Select how many rental entries are required.
3. Create rows and fill supplier GSTIN/name, reverse charge flag, supplier state, HSN, invoice number, monthly value, invoice day, and nature of expense.
4. For unregistered rent suppliers, keep supplier GSTIN as URP / Unregistered. Rental SAC defaults to 997212.
5. Save Rental RCM before GST Report Export.
6. During GST Report Export, Rental RCM is sent as a separate Excel file and is not mixed with the GSTR-1 Excel/JSON file.
7. For more than 5 offices, save in batches of 5.

Manual Invoice Process is optional. Use it only when you want to generate manual invoices separately, such as Corporate FD, P2P lending, or ND invoices, without running the complete CAMS/KFIN monthly process. Enter the required rows, choose whether generated PDFs should be mailed, and run the process. If you do not have manual invoices, ignore this section.

Use this option when an already-generated invoice needs correction. Load invoices from Consolidated, select the required row, add it to the edit list, and edit the required correction fields including broker invoice number if necessary. IGST or CGST/SGST is recalculated automatically from taxable value based on the original invoice tax mode. Use Mail Selected PDF Only when only the corrected invoice PDF is required. Use Regenerate Full Month Package when CAMS/KFIN month upload files also need to be recreated.

Use this when you want a fresh invoice-processing screen and a fresh upload cycle. It clears the live status, parsed-file memory, CAMS/KFIN source files, raw KFIN PDFs, and invoice final output folders. It does not delete Consolidated data, AMC Master, Vendor Master, settings, templates, or the client working Google Sheet.

If you see invalid credentials, permission denied, 401, or 403, click Authorize Drive again and login with the same Gmail. If Drive, Sheets, or Gmail API was enabled recently, wait a few minutes and retry. If folder not found appears, confirm the folder ID and the logged-in account's Drive access.

Enable Gmail API in the Firebase Google Cloud project, then click Authorize Drive again so Gmail send permission is captured. Confirm To email is present in Settings. CC and BCC must be valid comma-separated email IDs.

Google export can sometimes return busy, 429, deadline, or timeout messages. The app records the current step and can continue from the last completed stage. Use Pause / Resume after waiting for a short time. Do not reset unless you intentionally want to clear source and output files.

Confirm source files were uploaded to the correct CAMS or KFIN upload box. Use Reset & Clear Screen only if old parsed-file memory is preventing a fresh test. Check Live Activity for duplicate file messages. If a PDF format has changed, send the source PDF and log time to support.

Check that the consolidated invoice month is correct, invoice values are present, and bank statement date range covers both taxable and GST credits. The reconciliation primarily matches credit amounts and AMC/vendor recognition from statement narration when available; if only amounts are present, exact amount matching is used with tolerance.

Email advisortechhub@gmail.com with client Gmail, screen name, run time, affected month, source file name, and the exact error shown in Live Activity. For faster checking, include whether the issue happened before parsing, manual insertion, invoice number generation, PDF export, mail, reconciliation, or GST export.