Accounting Software Questions & Answers

To Auto Compute TDS in Inventory Entries in RealBooks, follow the steps given below:

• Open your RealBooks account
• Navigate to ‘master
• Click on ‘Account’
• Select ‘Rule TDS’
• Press Create
• Fill in the required details
• Click save
• Now record a purchase entry
• Navigate to ‘Transactions’
• Click on inventory
• Press purchase cycle
• Click purchase
• Input the required details
• Click on the ‘Compute’ option in the Item tab
• Click on the ‘Compute TDS’ option
• Click on ‘Submit’ to save the entry

To upload the IRNs in RealBooks, follow the steps given below:

• Open your RealBooks account
• Navigate to ‘Transactions’
• Click on ‘Import-Export’
• Select Import
• Select ‘E-Invoice’
• Hit ‘Download Template’
• Open the excel file
• Input the required details, make sure to enter the Voucher type the same as it is in RealBooks
• Save the file
• Navigate back to the ‘E-Invoice’ section in ‘Imports’ in RealBooks
• Click on ‘Choose file’
• Select the Excel file and click on upload
• Once the file is uploaded, you will be redirected to the Import listing page where you can check the upload status of the file
• Now, navigate to ‘Reports’
• Hit Compliance
• Select GST
• Press ‘GST E-Invoice'
• On the sale invoice report screen, run the report
• Click on the gear icon next to every transaction
• Select the ‘Manual E-Invoice updation’ option
• Enter IRN number, acknowledgement number and acknowledgement date
• Hit Submit

To calculate interest on loan in RealBooks, follow the steps given below:

• Open your RealBooks account
• Navigate to settings
• Click on ‘Configuration’
• Go to accounts
• Enable the ‘Interest calculation on Ledger’ option
• Navigate to ‘Master’
• Select ‘Accounts’
• Click on ‘Ledger’
• Press Create
• Input the required details and enable the toggle against ‘Activate Interest’
• Fill in the details on the interest details page
• Click on save
• Navigate to transactions>Accounts>Vouchers
• Select voucher type as receipt and add the necessary details
• Click submit
• Navigate to Transaction
• Click on Accounts
• Press on Vouchers
• Select voucher type as Payment
• Input the required details
• Click on the ‘Submit’ option
• Go to ‘Reports’
• Select Accounts
• Press Daily Reports
• Choose ‘Interest calculations’
• Search the loan account
• You will be able to see all the interest calculations

To create a company in RealBooks, follow the steps given below:

• Go to the official website of RealBooks
• Click on the ‘Get Started Now’ button
• Input your details and register to RealBooks
• Complete the company registration process

To Upload Purchase Entries using Excel in RealBooks, follow the steps given below:

• Open your RealBooks account
• Navigate to ‘Transaction’
• Click on ‘imports-Exports’
• Choose ‘Import’
• Select ‘Inventory Voucher’
• Download the template
• Open the Excel template
• Fill in the details in all the pages and enter the Voucher type as Purchase, which must be the same in RealBooks
• Save the file after filling in all the necessary details
• Navigate back to the ‘Inventory Voucher’ section in ‘Imports’
• Click on ‘Choose file’
• Select the file and click on Upload
• You will be redirected to the Import listing page once the file has been uploaded, where you can check the upload status
• Hit ‘CLICK’ to view the posted vouchers listing on daybook

To post Sale Entries via Excel Upload in RealBooks, follow the steps given below:

• Open your RealBooks account
• Go to ‘Transaction’
• Press on the ‘imports-Exports’ option
• Select ‘Import’
• Select ‘Inventory Voucher’
• Download the template
• Open the Excel template
• Add the details in all the pages and enter the Voucher type as Sale, which must be the same in RealBooks
• Save the file after filling in all the necessary details
• Navigate back to the ‘Inventory Voucher’ section in ‘Imports’
• Click on ‘Choose file’
• Select the file and click on Upload
• You will be redirected to the Import listing page once the file has been uploaded, where you can check the upload status
• Hit ‘CLICK’ to view the posted vouchers listing on daybook

To Book Manufacturing Journal in RealBooks, follow the steps given below:

• Open your RealBooks account
• Navigate to settings
• Click on ‘Configuration’
• Go to ‘Inventory’
• Click on Production
• Enable the toggle against ‘Manufacturing journal’
• Navigate to Master > Inventory > Activity > Create
• Enter the activity name and Cost Center name
• Click save
• Navigate to Master > Inventory > Activity rate > Create
• Select activity
• Set the applicable date
• Enter the per unit Rate
• Click on save
• Navigate to Master > Inventory > Resource > Create
• Enter the required details in the ‘General’ and the ‘Activities’ tab
• Click save
• Navigate to Transaction > Inventory > Production Module > Manufacturing
• Input the required details in all the tabs
• Click on Submit and save the entry

To Create Bills of Materials in RealBooks, follow the steps given below:

• Open your RealBooks account
• Navigate to Settings > configuration > inventory > production
• Enable the toggle against ‘BOM’
• Navigate to Master > Inventory > BOM > Create
• Input the required details and select ‘NO’ in the ‘use it for Planning’ section
• Click on the ‘Submit’ option
• NOTE: enable the BOM toggle in the item master of each item that will be used in BOM

To record Item Specifications in RealBooks, follow the steps given below:

• Open your RealBooks account
• Navigate to settings
• Click on ‘Configuration’
• Go to ‘Inventory’
• Click on Item
• Enable the toggle against ‘Item specifications’
• Create ‘item specification masters’ on the popup and click on save
• Navigate to Master > Inventory > Item specification > Create
• Input the required details and click save
• Navigate to Master > Inventory > Items > Create
• Add the necessary details and click save

To Post Receipt Entries via Excel in RealBooks, follow the steps given below:

• Open your RealBooks account
• Navigate to Transactions > Import-Export > Import > Accounts voucher
• Click on Download template
• Open the excel file
• Add the details in all the pages and enter the Voucher type as ‘Receipt’, which must be the same in RealBooks
• Save the file after filling in all the necessary details
• Navigate back to the ‘Accounts Voucher’ section in ‘Imports’
• Click on ‘Choose file’
• Select the file and click on Upload
• You will be redirected to the Import listing page once the file has been uploaded, where you can check the upload status
• Hit ‘CLICK’ to view the posted vouchers listing on daybook