How it Works
1
Suppose you paid a vendor and it shows in your bank statement as a...
Suppose you paid a vendor and it shows in your bank statement as a debit and a double-entry transaction only.
2
When you sync the transaction using the RazorpayX-Tally Integration...
When you sync the transaction using the RazorpayX-Tally Integration, you can use the Payout notes, Payout Purpose and other details from RazorpayX as a reference and update your journal entry narrations in TallyPrime.
3
Create a journal entry and reconcile payments easily.
Create a journal entry and reconcile payments easily.
Advantages
Following are the advantages of the bank statement sync flow:- It automates a lot of your bookkeeping and data entry processes.
- Reduce errors and inconsistency and save up on time.
- You do not need to maintain and cross-verify data between many Excel sheets.
Setup Workflow
Enable the Smart Bank Statement setting to sync all the transactions made in RazorpayX to Tally.- Navigate to R:RazorpayX Settings from your Gateway of Tally page.
- Select Yes against Sync Entries from RazorpayX. This is a one-time process.
Sync Transactions
After you enable the sync workflow to allow Tally to sync all the transactions you make in RazorpayX. FollowStart Sync
To sync these transactions in Tally:- Open Tally to show the Gateway of Tally page.
- Go to UTILITIES → RazorpayX.
- In the RazorpayX menu, click RazorpayX Bank Statement.
- Select RazorpayX Account when prompted to Select Ledger. The RX_Statement page appears.
Create Journal Entry
The Status of transaction synced reads Not Booked. This means that the journal entry is made but is incomplete in Tally. As such, it is also not posted to Tally. RazorpayX never posts journal entries directly to Tally. To create the journal entry:- Click on the relevant transaction synced to Tally. The Accounting Voucher Alteration page appears.
- On this page, check the Narration to the bottom-left corner. The narration contains the transaction details you can use as a reference when creating a journal entry.
- Create the journal entries by clicking on the By and To fields. Map the fields to the entities as present in your ledgers.
- Review your journal entry. Once statisfactory, enter Yes against Convert Voucher & Approval. You have successfully created and updated the particulars and narration of your journal. You have also booked the entry in Tally.
- Go to the RX_Statement page.
- Click on F10:Booked. It shows all the booked entries in journal. The latest entry you have booked will appear in the booked page.
Reconcile Entries
To reconcile the entries:- Go to Gateway of Tally.
- Navigate to UTILITIES → Banking → Bank Reconciliation.
- Here, select the Name of the Bank Ledger as RazorpayX A/c.
- Select the duration for which you want to view the entries by clicking F2:Period.
- Select B:Basis of Values and click Include Reconciled transactions from the drop-down list.
Related Information
- Keyboard shortcuts in Tally Prime
- Bring bills from RazorpayX to Tally
- Sync Vouchers in RazorpayX