https://www.teacheron.com/tutor-profile/7kvd?
I have more then 20 yr of experience in data processing Data Cleaning Data extracting accounting service tax income tax goods and service tax (GST) expertise in Tally Accounting Software and excel recently working in project of reading data behavior and analysis with software companies as a freelancer,
I m very old in this field but very new to this platform Plz give me the opportunity to learn how is this work and can i adjust here thanks a lot
Gst registration - Free
ReplyDeleteGstr 1,2,3, - 300 per/m
Incometax returns 300
Balance Sheet P&L - 500
Computation - 100
Food license - 3k
Pan - 150
Gumashta - 1200
Project Report 2k
And on-site & off-site accounting on very easy rate
(big team to cover arround Bhopal
Here are some commonly used shortcut keys in Tally:
ReplyDeleteALT + F1: To close a company
ALT + F2: To change the period in a report
ALT + F3: To select the company
ALT + F4: To quit Tally
ALT + F5: To view detailed ledger in Account Book
ALT + F8: To view Day Book
ALT + F9: To view Stock Summary
ALT + F12: To view Financial Statements
ALT + 2: To duplicate a voucher
ALT + A: To add a voucher
ALT + C: To create a master at a voucher screen
ALT + D: To delete a voucher
ALT + E: To export data
ALT + I: To insert a voucher
ALT + M: To modify a voucher
ALT + N: To view the report in a single-screen mode
ALT + P: To print the report
ALT + R: To remove a line in a report or a voucher
ALT + S: To bring back a line you removed using ALT + R
ALT + V: To view voucher types
Familiarize yourself with the Tally interface: Take some time to explore and understand the different sections, menus, and options available in Tally. This will help you navigate and use the software more effectively.
ReplyDeleteSet up your company correctly: When creating a new company in Tally, ensure that you provide accurate and complete information, including company name, address, financial year, and statutory details. This will help in generating accurate reports and complying with legal requirements.
Use keyboard shortcuts: Tally provides various keyboard shortcuts to perform actions quickly. Learning and using these shortcuts can save you time and make your data entry process more efficient. Refer to the Tally documentation or help files for a list of keyboard shortcuts.
Customize Tally as per your needs: Tally allows you to customize the interface, reports, and printing formats according to your preferences. Explore the customization options to tailor Tally to your specific requirements.
Regularly backup your data: It's essential to regularly backup your Tally data to prevent loss of important information in case of system failure or any other unexpected events. Tally provides backup and restore options within the software for this purpose.
Use Tally shortcuts and automation features: Tally offers features like voucher templates, memorized vouchers, recurring entries, and automatic bank reconciliation to streamline and automate your accounting processes. Utilize these features to simplify your work and improve accuracy.
Reconcile bank accounts and ledgers: Regularly reconcile your bank accounts and ledgers in Tally to ensure that your books match the actual financial transactions. This will help identify any discrepancies and maintain accurate financial records.
Generate and analyze reports: Tally provides a wide range of reports that can help you analyze your financial data, track expenses, monitor sales, and assess the overall performance of your business. Utilize these reports to gain valuable insights and make informed decisions.
Stay updated with Tally releases and upgrades: Tally releases regular updates and new versions with enhanced features, bug fixes, and regulatory compliance changes. Stay updated with these releases and consider upgrading to the latest version to access new functionalities and ensure smooth operation.
Seek professional assistance if needed: If you are new to Tally or encounter complex accounting scenarios, don't hesitate to seek help from Tally experts or professionals who are well-versed in using the software. They can provide guidance and assistance to ensure accurate accounting practices.
Remember, practice and hands-on experience are crucial for mastering Tally. The more you use the software, the more comfortable you will become with its features and functionality.
Cleaning data in Excel involves various techniques to remove unnecessary or incorrect information, format data consistently, and ensure data accuracy. Here are some tips for cleaning data in Excel:
ReplyDeleteRemove duplicate values: Select the data range, go to the "Data" tab, and click on the "Remove Duplicates" button. Excel will prompt you to choose the columns to check for duplicates and remove them, leaving only unique values.
Trim leading or trailing spaces: Extra spaces at the beginning or end of cell contents can cause issues when sorting or filtering data. Use the TRIM function to remove leading and trailing spaces. For example, if the data is in column A, you can use the formula "=TRIM(A1)" in cell B1 and drag it down to apply the function to the entire column.
Filter and sort data: Use the filter and sort functions to organize and analyze your data effectively. Click on the "Sort & Filter" button in the "Home" tab to sort data in ascending or descending order. You can also use the "Filter" option to display specific data based on criteria.
Remove blank cells: Select the data range, press "Ctrl+G" to open the "Go To" dialog box, click on the "Special" button, choose "Blanks," and click "OK." This will select all the blank cells in the range. Right-click on any selected cell, choose "Delete," and select "Shift cells up" to remove the blank cells.
Identify and handle errors: Excel provides various functions to handle errors in data. Functions like IFERROR, ISERROR, and ISNA can help identify and replace error values with meaningful data or appropriate error messages.
Validate data entry: Use data validation rules to ensure that only specific types of data are entered in a particular column. This helps maintain data integrity and consistency.
Format data consistently: Ensure that data is formatted consistently across columns. For example, you may want to use the same date format, currency format, or number format throughout the data range.
Use text functions: Excel offers various text functions to manipulate and clean text data. Functions like UPPER, LOWER, PROPER, CONCATENATE, and SUBSTITUTE can help modify text data as needed.
Check for data accuracy: Review your data for any inconsistencies, outliers, or incorrect entries. Use Excel's functions and formulas to perform calculations and verify the accuracy of numerical data.
Backup your data: Before making any significant changes or cleaning operations, it's always a good practice to create a backup copy of your original data. This ensures that you can revert to the original data if needed.