
In Progress
Posted
I have exported the full purchase ledger from Zoho Books and now need a clean, verifiable audit that reconciles those entries with the corresponding figures in GSTR-2B and GSTR-3B. Every vendor bill must show whether it is fully or partially matched, the exact GST variance (if any), and the payment that cleared it—right down to the individual bill level. The finished audit has to sit in a single, well-structured Excel file so I can filter by vendor, invoice date, GST rate, or payment status without extra manipulation. Deliverable – one workbook containing: • A master sheet that lists each Zoho Books purchase bill alongside its matching entry (or mismatch) in GSTR-2B and GSTR-3B. • A payment-mapping sheet that ties every outgoing payment to the exact bill(s) it settled, with any unallocated balances clearly flagged. • Summary pivots or dashboards highlighting total reconciled value, discrepancies, and unpaid or partially paid invoices. The work will be accepted once all invoices in the current fiscal year are traceable from Zoho Books through to GST returns and linked payments, with no blank or ambiguous cells in the reconciliation columns. Please keep formulas intact so I can review your logic.
Project ID: 40561101
32 proposals
Remote project
Active 22 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi, I’d be happy to assist with reconciling your Zoho Books purchase ledger with GSTR-2B and GSTR-3B and preparing a clear, audit-ready Excel workbook. I have experience in GST reconciliations, purchase ledger verification, payment mapping, and advanced Excel reporting. I can prepare a structured workbook that matches each purchase bill with the corresponding GSTR-2B and GSTR-3B entries, identifies GST variances, maps payments to individual bills, and highlights any unmatched or partially paid transactions. The final workbook will include a master reconciliation sheet, a detailed payment-mapping sheet, and Pivot Table summaries/dashboard for quick analysis. All formulas will remain intact, and the workbook will be fully filterable by vendor, invoice date, GST rate, payment status, and reconciliation status, making it easy to review and audit. I focus on accuracy, consistency, and clear documentation to ensure every invoice is traceable from Zoho Books through GST returns and payment records. I'm available to start immediately and look forward to discussing your project. Best Regards, Sumit Adlakha
₹100 INR in 40 days
1.8
1.8
32 freelancers are bidding on average ₹292 INR/hour for this job

5x Certified Zoho Professional Hey, I am Fateh Singh, with 9-year experience in ZOHO Eco System and extensive knowledge of Business processes and Customization/Development. Core Competencies : • ZOHO Consultancy • API Integration • Configurations & Customisation • App Development • Data Migration • ZOHO Training • Support I have good exposure to different areas of ZOHO like • Custom Modules • Custom Fields • Canvas • Widgets • Blueprints • Schedules • Workflows • Validations • Advanced Formula • Deluge • Security Control • Process Management • Automations • Data Administration • General System Setup • Channels Setup • Portals • Reports and Dashboards
₹850 INR in 40 days
5.7
5.7

Hello, I'd be happy to assist with your Zoho Books and GST reconciliation project. I hold an **MBA** and have extensive experience with **Zoho Books, Excel, financial reconciliation, GST reporting, and audit-ready financial analysis**. I have worked on projects involving purchase ledgers, payment mapping, financial reporting, and complex Excel models with formulas and pivot tables. I can provide: • Complete reconciliation of Zoho Books purchase bills with **GSTR-2B** and **GSTR-3B** • Bill-level matching showing full, partial, or unmatched status • GST variance analysis for every invoice • Payment mapping linking each payment to the corresponding bill(s) • A well-structured Excel workbook with formulas, filters, and pivot summaries • Dashboard highlighting reconciled values, discrepancies, and outstanding invoices I pay close attention to accuracy, ensuring every invoice is fully traceable while maintaining transparent formulas for easy review. I can start immediately and deliver a clean, audit-ready workbook within your required timeline. Best regards.
₹300 INR in 70 days
2.4
2.4

I'm Practicing CA in Noida, Every purchase bill traced from Zoho Books through GSTR-2B/3B to the exact payment that cleared it — matched, variances flagged, no blank cells. That's the standard I'll deliver. I'm Puneet, a Chartered Accountant with direct experience in GST reconciliation and vendor-level audit work for corporate clients with large transaction volumes. How I'll structure the workbook: - Master Sheet: Each Zoho bill vs its GSTR-2B/3B match, with match status and GST variance via formulas - Payment-Mapping Sheet: Each payment tied to the bill(s) it settled, unallocated balances flagged - Summary Dashboard: Pivot view of reconciled value, discrepancies by vendor/GST rate, unpaid/partial invoices - Fully filterable by vendor, date, GST rate, or payment status - Formulas kept intact and visible for your review I'll work through the full fiscal year vendor by vendor, flagging anything unclear rather than leaving blanks. Approx. how many vendors/bills for the year, and is GSTR-2B/3B data available as Excel/JSON exports, or do I pull it from the portal?
₹400 INR in 40 days
0.8
0.8

Hello, I can assist with preparing a detailed reconciliation of your Zoho Books purchase ledger with GSTR-2B, GSTR-3B, and payment records in a fully traceable Excel workbook. As a **Finance & Tax Professional**, I have hands-on experience with GST reconciliations, Zoho Books, Excel automation, and financial data analysis. My deliverables will include: • Bill-wise reconciliation between Zoho Books, GSTR-2B, and GSTR-3B • GST variance analysis with fully/partially matched status • Payment mapping linking each payment to the corresponding purchase bill(s) • Identification of unmatched, partially paid, and unallocated transactions • Pivot-based summary dashboards highlighting reconciliations, discrepancies, and outstanding balances • Transparent formulas and a well-structured workbook for easy review and future updates I focus on accuracy, traceability, and audit-ready documentation. I am available to start immediately and can deliver a clean, fully reconciled workbook within the agreed timeline. Thank you
₹100 INR in 40 days
0.0
0.0

Dear Sir, I can help you reconcile your Zoho Books purchase ledger with GSTR-2B and GSTR-3B and prepare a clean, well-structured Excel workbook. My services include: Reconciliation of purchase invoices with GSTR-2B and GSTR-3B. Identification of fully matched, partially matched, and mismatched entries. GST variance analysis at the invoice level. Payment mapping for each vendor bill. Preparation of a master reconciliation sheet, payment mapping sheet, and summary dashboard with formulas intact. I have experience working with GST compliance, Tally, Zoho Books, and Excel, and I pay close attention to accuracy and detail. I will ensure the workbook is easy to review, filter, and verify. I am available to start immediately and will deliver the work within the agreed timeline Best regards, Akansha Sharma
₹100 INR in 40 days
0.0
0.0

I noticed your need for a meticulous Zoho Books GST purchase audit, requiring a detailed reconciliation with GSTR-2B and GSTR-3B entries, down to individual bill levels. I specialize in providing clean, professional, and user-friendly audit solutions. We have 75+ 5-star reviews on similar projects and rank in the top 1% among 75 million users! Our expertise lies in creating seamless Excel workbooks that allow easy filtering by vendor, invoice date, GST rate, and payment status. We ensure every bill is matched accurately, with clear GST variance and payment details. Can you share more details about your timeline for this project? Your prompt response will be highly appreciated. Regards, Hamza
₹200 INR in 7 days
0.0
0.0

I have strong experience with GST reconciliations, Zoho Books exports, and Excel-based audit work. I can reconcile your purchase ledger against GSTR-2B and GSTR-3B at the individual invoice level, identify GST variances, map payments to corresponding bills, and build a clean, fully traceable workbook with intact formulas, filters, pivots, and discrepancy dashboards. All invoices will be reviewed for matching status, payment linkage, and reconciliation accuracy to ensure a transparent and verifiable audit trail for the current fiscal year.
₹300 INR in 20 days
0.0
0.0

I have carefully reviewed your project details for the Zoho Books GST Purchase Audit. I understand that you need a precise reconciliation of 500 bills from Zoho Books with GSTR-2B and GSTR-3B, along with a clean, structured Excel workbook containing a master sheet, payment-mapping, and summary dashboards. Although I am new to this platform and looking for my first client, I am highly proficient in Zoho Books, Indian GST Laws, and advanced Excel features like Pivot Tables and filtering. I will ensure 100% accuracy in detecting variances and clearing individual bill-level data without any manual manipulation errors. Since I am building my profile, your satisfaction is my top priority. I am ready to offer a competitive hourly rate and can dedicate immediate time to deliver this accurately within your timeline. I would love to discuss this further. Looking forward to hearing from you! Best regards, ['AATUSH KUMAR"]
₹110 INR in 10 days
0.0
0.0

Have a brilliant company concept but don’t know where to start? I specialize in transforming raw business ideas into market-ready realities. As an end-to-end project manager and consultant, I handle the heavy lifting of turning your vision into a structured plan.
₹250 INR in 40 days
0.0
0.0

Here are a few options under **100 characters**: 1. GST reconciliation expert. Accurate Zoho Books, GSTR-2B & GSTR-3B matching in Excel. 2. Expert in GST & Zoho reconciliations with accurate, audit-ready Excel deliverables. 3. Accurate GST reconciliation, payment mapping & audit-ready Excel reports. 4. Experienced in Zoho Books, GST reconciliation & invoice-level audit reporting. 5. Can deliver accurate, traceable GST reconciliation with clean Excel reports.
₹280 INR in 20 days
0.0
0.0

Hi there, I have read your project requirement. You need a complete reconciliation of your Zoho Books purchase ledger with GSTR-2B and GSTR-3B, along with bill-wise payment mapping and a well-structured Excel workbook containing reconciliation, GST variance analysis, and summary dashboards with intact formulas. We can thoroughly reconcile every purchase invoice, identify full and partial matches, calculate GST variances, map payments to individual bills, and deliver a clean, filterable Excel workbook with dashboards for easy review and future audits. I have a few questions: =================== Will you provide the Zoho Books purchase ledger, GSTR-2B, GSTR-3B, and payment reports in Excel/CSV format? Does the reconciliation cover a single financial year or multiple GST periods? Are there any manual journal entries, credit notes, or debit notes that should be included in the reconciliation? Do you require a final exception report with recommendations for correcting mismatches? Best Regards, Srashtasoft Team
₹550 INR in 40 days
0.0
0.0

I am CA Finalist specialized in Indian Tax Compliance and advanced Excel modeling. I routinely execute complex multi-source reconciliations, identifying discrepancies between internal ledgers and GST returns (GSTR-2B/3B). Using advanced formulas, I will deliver a clean, formula-intact, audit-ready master workbook with zero hardcoded values. I already have one excel workbook regarding mismatching of ITC, due to this I can deliver you the servise in less time. Ready to start immediately. Looking to hear from you.
₹250 INR in 10 days
0.0
0.0

Hi there, Matching Zoho Books purchase bills against GSTR-2B and GSTR-3B down to the bill level doesn't leave room for a blank cell or a loose end - everything has to trace cleanly. I have 10+ years of bookkeeping and reconciliation experience, working extensively in Excel for detailed audits, vendor-level matching, and GST-related reconciliations across multiple accounting systems. HERE'S HOW I'D HANDLE THIS : -- Pull the full purchase ledger from Zoho Books and match each bill against GSTR-2B and GSTR-3B, marking full, partial, or mismatched status -- Calculate the exact GST variance for every bill, with no blank or ambiguous cells -- Build a payment-mapping sheet linking each outgoing payment to the exact bill(s) it settled, flagging any unallocated balances clearly -- Add summary pivots/dashboards for total reconciled value, discrepancies, and unpaid or partially paid invoices -- Keep all formulas intact and the workbook filterable by vendor, date, GST rate, or payment status — no manual cleanup needed on your end Happy to walk through my approach in a quick call before starting, if useful. Best regards, Rekha
₹250 INR in 40 days
0.0
0.0

Hello, I am a Chartered Accountant with 22+ years of experience in financial planning, compliance, and audit processes. I have worked extensively with ERP systems, GST reconciliations, and Excel-based reporting, which makes me well-suited for this assignment. For your requirement, I will: Reconcile Zoho Books purchase ledger entries against GSTR‑2B and GSTR‑3B, ensuring every vendor bill is fully traceable. Flag mismatches and GST variances at the individual bill level, with clear notes on partial matches. Map payments to bills in a dedicated sheet, highlighting unallocated balances. Deliver a structured Excel workbook with master reconciliation, payment mapping, and summary pivots/dashboards for easy filtering by vendor, invoice date, GST rate, or payment status. Keep formulas intact so you can review the logic transparently. I will ensure no blank or ambiguous cells in reconciliation columns, and the final workbook will be clean, verifiable, and ready for audit review. Why me: Deep expertise in GST compliance and reconciliations. Strong command of Excel (pivot tables, dashboards, formulas). Proven ability to deliver accurate, audit‑ready outputs. I am available to start immediately and will prioritize accuracy, clarity, and timely delivery. Looking forward to supporting your GST reconciliation needs.
₹300 INR in 50 days
0.0
0.0

Hello, We'd be happy to assist you with this **GST reconciliation and purchase audit**. This assignment requires more than just matching data—it requires a detailed reconciliation to ensure every purchase invoice is accurately linked with GST returns and payment records. As a Chartered Accountant firm with 10+ years of experience, we regularly perform **Zoho Books to GSTR-2B/GSTR-3B reconciliations**, vendor ledger reviews, payment mapping, and GST compliance audits for SMEs. We'll prepare a fully linked Excel workbook containing a master reconciliation of purchase bills with GSTR-2B and GSTR-3B, bill-wise GST variance analysis, payment mapping, outstanding balances, and summary dashboards with intact formulas for complete transparency and easy review. Our review process also identifies duplicate claims, missing invoices, unmatched ITC, vendor reporting mismatches, and other discrepancies that may impact GST compliance. The final workbook will be clean, well-structured, and fully traceable, making it suitable for management review, statutory audit, and future GST assessments. Let's discuss your data volume, timelines, and pricing over chat. We'd be happy to help you complete this reconciliation accurately and efficiently.
₹100 INR in 40 days
0.0
0.0

Hello, I can help you create a complete purchase reconciliation between Zoho Books, GSTR-2B, and GSTR-3B with a clean, fully traceable Excel workbook. With extensive experience in Zoho Books, data reconciliation, Excel, and financial reporting, I will: * Reconcile every Zoho Books purchase bill with the corresponding GSTR-2B and GSTR-3B entries. * Identify full matches, partial matches, missing invoices, and GST variances. * Map every outgoing payment to the exact bill(s) it settles and flag any unallocated balances. * Build a well-structured Excel workbook containing: * A master reconciliation sheet. * A payment mapping sheet. * Summary dashboards and pivot tables showing reconciled values, discrepancies, unpaid, and partially paid invoices. * Keep all formulas intact and ensure every invoice is fully traceable from Zoho Books through GST returns and payments. I pay close attention to accuracy and data integrity, ensuring there are no blank or ambiguous reconciliation fields. I can begin immediately and deliver a clear, audit-ready workbook. I look forward to working with you. Best regards, Tanveer Ahmad Zoho Books | Zoho Analytics | Excel Data Reconciliation Specialist
₹250 INR in 40 days
0.0
0.0

I can reconcile your Zoho Books purchase ledger with GSTR-2B and GSTR-3B at invoice level, identify GST variances, and map payments to the corresponding bills. The final Excel workbook will include a master reconciliation sheet, payment mapping, and summary dashboards with formulas intact for complete audit transparency and review.
₹100 INR in 41 days
0.0
0.0

Hello, I am Yugandhar, have 18+ years exposure in Accounting includes, GL Accounting, Reconciliation, and GST and VAT. My profile fits best to the requirements. I have a proven track record with high accuracy all over my career. You are looking for a deliverables with high accuracy, i can assure the same. Regards, Yugandhar
₹100 INR in 40 days
0.0
0.0

I have experience preparing GST reconciliation workbooks that compare purchase registers with GSTR-2B and GSTR-3B, including invoice-level matching, booking month vs. reflection month analysis, GST variance identification, and filterable Excel reports. I can extend this to include payment mapping and dashboards while keeping all formulas transparent for review.
₹300 INR in 30 days
0.0
0.0

I can deliver a complete bill-level reconciliation between Zoho Books, GSTR-2B, GSTR-3B, and payment records in one clean Excel workbook. The file will include invoice matching status, GST variances, payment mapping, and formula-based dashboards for full audit traceability. Every transaction will be linked end-to-end with clear discrepancy flags and review-ready logic.
₹100 INR in 40 days
0.0
0.0

Noida, India
Payment method verified
Member since Apr 17, 2025
₹600-1500 INR
₹100-400 INR / hour
₹100-400 INR / hour
₹100-400 INR / hour
₹600-1500 INR
₹1500-12500 INR
$15-25 USD / hour
£250-750 GBP
₹12500-37500 INR
$30-250 USD
₹12500-37500 INR
₹750-1250 INR / hour
₹600-1500 INR
€2-6 EUR / hour
€25-100 EUR
£18-36 GBP / hour
$30-250 USD
₹1500-12500 INR
₹600-1500 INR
$250-750 USD
₹600-1500 INR
$750-1500 AUD
₹600-1500 INR
£20-250 GBP
₹75000-150000 INR