Find Solutions to Common Issues Related to accounting-reports - account books
In BUSY, the following books of accounts and registers are maintained automatically:
1. Cash Book: Records all cash transactions.
2. Bank Book: Tracks all bank transactions.
3. Sales Register: Maintains a record of all sales transactions.
4. Purchase Register: Keeps track of all purchase transactions.
5. Journal Register: Records all non-cash transactions.
6. General Ledger: Maintains a summary of all accounts.
7. Trial Balance: Provides a summary of all ledger balances.
8. Profit and Loss Account: Shows the company's income and expenses.
9. Balance Sheet: Provides a snapshot of the company's financial position.
10.Inventory Books: Provides a detailed sale register with item details.
11.Stock status: Provides detailed and summary report of closing stock.
These books and registers are automatically updated as you enter transactions in BUSY.
If you want to add Custom columns in Bulk, follow these steps:
Step 1: Open your report. On the upper side, you will find the options for custom columns.
Step 2: Click on custom column, then give a name in the format name field.
Step 3: Mention the heading Name, position, data type, alignment, and character.
Step 4: In the field value details, choose the data field.
Step 5: In the data field option, choose the category.
Step 6: Then choose the column you want in the report & save.
Step 7: Then add Other Columns by follow Steps 4 to 6 & save
Step 8: If you do not want to see any predefined column, untick the column.
Step 9: Save the field and format.
Step 10:Now reopen the report with the format name that you created.
To add transporter details in sales report you need to follow the steps
1 go to transaction menu and click on sale then click to list
2 select date range and ok to open the report
3 click on custom column and put a name
4 Click on add column fill the heading name as transporter select the required position
and select data type as text
5 select alighnment to show the report and select the character number of custom field
6 select data field and click on category and select inventory vouvcher header field
7 click on fields then click on voucher hedaer and select the field transport
8 click on save field and save format then open the sale list with the new report format
If you want to add custom column then please follow the given
steps
Step 1: Open desired reports then click on the custom columns
then enter the format name.
Step 2: Then click on add new col then enter the heading
then select the position then select data type then
alignment then no of chars.
Step 3: Then select data field then select category as per
the field requirement.
Step 4: Then select master name col if you select account master
or item master in the category field then click on the
fields button and and search the field and enter.
Step 5: Then click on save fld. button then exit.
Step 6: While opening report you need to select format name
instead of standard to see the cusomized report.
Clubbed cash and bank books will display both cash and bank data in a single report. In BUSY , we are required to create columnar report for bank and cash books.
To get the clubbed report of cash and bank books follow the below steps:
Step 1: For creating columnar report , Go to administration > configuration > columnar reports > Cash/Bank book > Select Bank/ cash accounts and save the configuration ( Press F9 key to delete row if required ).
Step 2: For open the clubbed report , Go to display > account books > Cash/Bank book > multiple column > Open.
It will reflect all selected cash/bank account data in a single report.
Remark - Maximum 5 cash/bank accounts can be selected for configure cash/bank columnar report.
You can access various reports related to sales, purchases, inventory, etc. in BUSY by following these steps:
Step 1: Open BUSY and select the company you want to work with. Then, go to the Display tab on the top menu bar.
Step 2: Under the Display tab, select Account Books and then click on Account Registers (Standard). This will open a list of different reports that you can choose from, such as sales register, purchase register, etc.
Step 3: To view the inventory status of your items, go back to the Display tab and select Stock Status. This will show you the current stock position of your items along with their rates and values.
Step 4: Sort on party name alphabetically click on party name tab
BUSY provides a variety of accounting reports to help you to manage your business finances effectively. Some of the reports are:
1. Financial Reports: These include Balance Sheet, Profit & Loss Account, Trial Balance, etc.
2. Account Books: These include Account Ledger, Sales Register, Purchase Register, etc.
3. GST Reports: These include GSTR-1, GSTR-2, GSTR-3B, GSTR-4, GSTR-9, etc. These reports help you to comply with the GST laws and regulations in India.
4. Outstanding Analysis Reports: These include Bills Receivables, Bills Payables, Aeging Reports, etc. These reports help you to manage your cash flow and credit control.
5. MIS Reports: These include Profitability Report, Cash Flow, Fund Flow, Ratio Analysis, Multi Company Results, etc.
The data in these reports updates automatically on real time basis.
To identify and fix discrepancies in your accounts in BUSY, you can follow these steps:
Step 1. Review your account ledgers, balance sheets, and reports to identify any inconsistencies or discrepancies.
Step 2. Cross-verify opening and closing balances to pinpoint the specific accounts where issues exist.
Step 3. Check the vouchers and entries related to those accounts for any errors or incorrect data.
Step 4. Make adjustments and rectify any data entry mistakes or inaccuracies.
Step 5. Match invoices and receipts to ensure they are accurately recorded.
Step 6. Reconcile and verify GST amounts voucher-by-voucher between BUSY and the government portal.
Step 7. Update to the latest version of BUSY to ensure you have the most recent bug fixes and improvements.
Step 8. Take backups of your data before making any changes or corrections.
If some partial data is displaying in data, check the possible reason:
1.Confirm that if the invoice is posted with a zero value, it will not appear in the report.
2.If a particular voucher has been canceled, it will also not appear in the ledger report.
3.Confirm that the correct party is selected in the purchase voucher, and make corrections if needed.
4.Check if any other account is incorrectly tagged in the item master instead of the purchase or sales account. Correct the tagging if the wrong account is updated and then resave the invoice.
5.If the wrong account is tagged in the purchase or sales type, correct the account tagging in the purchase/sales account information field, and resave the invoice.
6.Check the company you are checking, must be the correct one.
To export invoice from BUSY, you can follow these steps:
Step 1: First open the invoice and click on the Print button or press ALT+P. Then, you need to select your format and click on Export button or press ALT+E.
Step 2: Choose Data Format such as PDF, HTML or XML and press OK.
To view & export payment report in BUSY, you can follow these steps:
Step 1: Go to the Display menu and click on Account Books.
Step 2: Select Account Registers(Standard) and Choose Payment Register.
Step 3: Enter the date range and can view the report.
To export that report use the Export (ALT+E) option to export it in a compatible file format such as Excel, CSV, PDF & Google Sheet.