Accounting · Excel voucher import
Busy Accounting export for RA bills
Certified RA bills export as a sales voucher sheet laid out for Busy's Excel import, with GST, TDS and retention in their own columns.
Data that moves each way
Only these items move, only for the work orders you turn on.
- To Busy Accounting
Certified RA bills as sales vouchers, one row per bill
Out - To Busy Accounting
GST, income-tax TDS, GST TDS and retention as separate columns
Out - From Busy Accounting
Account masters exported from Busy, for mapping
In
Field mapping. Tatha Vastu to Busy Accounting.
| Tatha Vastu | Busy Accounting |
|---|---|
| Client | Party account |
| RA bill number and date | Voucher number and date |
| Value of work done, certified | Sales account amount |
| GST on the invoice | Tax columns |
| Income-tax TDS | TDS receivable account |
| Retention held | Retention receivable account |
Setup in 4 steps
- Export your account masters from Busy as Excel and upload them in Tatha Vastu, under Integrations.
- Map each work order's client to its Busy party account, and each bill head to an account.
- After certification, download the voucher sheet for the month.
- Import the sheet through Busy's Excel import for sales vouchers, using the column layout Tatha Vastu provides.
- 1. Export your account masters from Busy as Excel and upload them in Tatha Vastu, under Integrations.Done
- 2. Map each work order's client to its Busy party account, and each bill head to an account.Done
- 3. After certification, download the voucher sheet for the month.Done
- 4. Import the sheet through Busy's Excel import for sales vouchers, using the column layout Tatha Vastu provides.Now
Is the Busy link live or file based?
File based. Tatha Vastu builds an Excel sheet in the layout Busy imports, and you import it in Busy.
Can we export a whole month at once?
Yes. The voucher sheet can hold every bill certified in a date range, across work orders.
What if a client is missing from our Busy masters?
The sheet lists unmapped clients first, so you can create the party account in Busy before the import.
Does it read payments back from Busy?
Upload a receipts export from Busy and Tatha Vastu matches each receipt to its bill by number and amount.