Computerized Accounting

Course Contents:
1. Excel Advanced
2. Peachtree
3. Excel Advanced
4. Tally
5. Project

Advanced Excel
This program is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

Program Objectives
This Advanced Excel training program will empower the participants to be able to do the following:
Performing complex calculations more efficiently, using various Excel functions.
Organizing and analyzing large volumes of data.
Creating MIS reports.
Designing and using templates.
Consolidating and managing data from multiple workbooks.

Audience
Executives and managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.

Prerequisites
Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.

TALLY (Financial Accounting)
1. Maintain Accounts using different Currencies other then the home currency.
2. Forecasting using Budgets feature of tally. You can make Departmental Budget, Financial Budget and Marketing Budget.
3. Budget features are used to compare against actual to Display Variance.
4. How to handle and maintain Accounts of a Manufacturing company.

Cost Centers

1. Allocating EXP and Income (Revenue) to the different branches of the company inside Bombay or all Over India. Maintaining Accounts related to Cost Centers Using Tally’s Advance features of TDS (Tax Deducted at Source).
2. Using Tally’s Advance features of VAT (Value Added Tax)
3. How to Import and Export Tally Data

Ratio Analysis. (Explained in Detail)
Reports showing you the state of the companies financial health and where it is going in short term. (Ratio Format). Using E-capabilities. (Email) features of Tally.

Cash and Fund Flow statement

1. How to ascertain
2. Cash Flow summary- Cash Movement- Inflow and Outflow of cash only.
3. Fund Flow summary- Movement of entire Working Capital.
4. Recall source of fund and how they are applied

Scenario Management

Useful in reports with provisional figures without actually putting the entries through the main books and for forecasting purposes, by passing necessary Vouchers Exploring the QUERY features of Tally

Salient Features


Saves time.
Accuracy.
Various accounting books are created within seconds i.e. cash book, ledger book, purchase book, sales purchase.
Financial statements within minutes i.e. Trading A/C, Profit and loss A/C, Balance sheet.

Application

Tally is used by all type of business houses like Proprietor firm, Partnership firm, Non-profit making Organizations, Mnc companies.

Peachtree Software: 5 Essential Benefits
Launching and running a business can be a daunting undertaking, especially when it comes to the accounting end of things. If you're seeking the ultimate software to manage your business accounting needs. Whether starting your own accounting firm or using accounting software to manage another type of small business, Peachtree has the versatility necessary so it can be integrated for any type of use. Let's look at five key benefits of using Peachtree software.

1. Years of Experience and Growth
Peachtree business software has been around for decades and has grown sufficiently in this age of technology. As if the years of experience weren't enough, Peachtree has consistently been tweaked to better serve business needs. It has also been upgraded time and time again to meet the demands of the technology age. Any accounting software that is meant to last must keep up with new computer systems, such as Windows upgrades, and must be online-friendly for those businesses that conduct most of their operations online. Peachtree receives an "A++" in both these areas. Your benefit is that you never have to worry about it becoming outdated or obsolete as many software systems do.

2. Versatility at Its Best
Peachtree is known for its versatility, meaning it can be used with any type of business. There are many features to help you customize Peachtree to your particular business, whether your business is small or large. You can pick and choose from more than 100 forms, and use only the features needed for your business. For example, if you only want to track sales and monitor inventory, you can use these features. Or, if you need to keep up with employee payroll, invoices, checks, etc. then Peachtree can easily be set up to do these tasks. You can also customize Peachtree to certain types of businesses, such as manufacturing.

3. Eliminate the Need for Other Software Programs
With Peachtree, you can save time, dollars and hard drive space by eliminating other less functional software programs. Peachtree offers so many features that it can take care of virtually every business office task. So, instead of having three or four different software programs, you can consolidate all your functions into one. Also, keep in mind that Peachtree can easily "grow" with your business. You can opt to use various features in the program as you need them or upgrade to a more functional version of Peachtree later!

4. Multiple Software Options
Peachtree software is available in several versions to meet the demands of any company. Peachtree Pro is the most basic edition, with great features for the small business that has cut and dry bookkeeping needs. Peachtree Complete adds job costing, in-depth inventory features, time and billing and analysis tools along with a multi-user option to increase productivity. Peachtree Premium has premium features such as advanced budgeting, multi-company consolidations, multi-user option, screen-level access control, and Crystal Reports(R). Peachtree support many users and has advanced tracking settings as well as security features. It has all the features as Peachtree Premium Accounting with support and upgrades.

5. Beginner and Advanced Training Available
No matter which Peachtree version you buy, there are beginner and advanced training classes available to help you set up and use your software. Training minimizes the need for support later and helps you to capitalize on all the great features that can help your business run more smoothly. There are also instructors that will come to your place of business to set up your software and provide on-site training.

Quick Books Training & Setup

Quick Trainer's One-on-One Training is for the business:
Who has very specific needs and/or "How To" questions about QuickBooks.
Desires a QuickBooks expert to review the books and outline where the issues are.
Who perhaps cannot spend a day away from the business in order to take a QuickBooks Class.?

What does QuickBooks Training entail?
QuickBooks Training entails teaching businesses, on a personal level, how to efficiently and effectively use QuickBooks to their advantage.
Our Training is conducted on a One-on-One (or 1-on-2, etc.) basis, typically within your own space.
QuickBooks Training is always tailored to your specific needs.
Not sure what your needs are? This is not a problem for Quick Trainer. We know how to quickly uncover your QuickBooks and accounting issues.
Once uncovered, we will create a plan to resolve these issues.

What are the benefits of QuickBooks One-on-One Training?
If you want to ensure that your data is setup correctly from the start, or if you want an analysis of the current state of your data, Quick Trainer specializes in QuickBooks Setup.
Personal training, offered on a One-on-One (or 1-on-2, etc.) basis.
Our training is tailored to your specific needs and desires.
We utilize your QuickBooks data file and your real data (e.g., Checks, Deposits, Credit Card Charges, etc.).
Our training allows you to quickly get a handle on your specific issues.
We come to you or another mutually agreed upon location such as Port City Java. An alternate location is ideal if you are likely to be interrupted frequently during the course of training.
Our training is typically designed to be conducted in 2 hour per day 3 days per week or offer Executive Classes.

Data File Setup
QuickBooks data file setup (or implementation) is for the business who is:
Just getting started with QuickBooks and wants to ensure their QuickBooks file is setup properly for their success. This setup will typically include end-user training as well as the initial setup.
Alternatively, a business will want to create a new QuickBooks. Perhaps their original QuickBooks file has 5 - 10 years worth of data and the business simply wants to archive the old while keeping 12 months worth of historical data. This pursuit requires a QuickBooks data file that is setup properly and some consulting is typically involved to ensure historical data is brought over properly.

What if my QuickBooks data file is a mess; a disaster?
First and foremost, rest assured, you are not alone. On an almost daily basis we encounter QuickBooks data in need of serious help. We frequently find new clients fear they have the worse QuickBooks data file we have ever seen. We sincerely doubt this is true, but let us be the judge. Otherwise, there is no need to be embarrassed. After all, you don't know what you don't know. Furthermore, it's one of the reasons QuickTrainer has been so successful; clients need our help and we love helping others!

Identify the issues within QuickBooks
Cleanup the issues and then teach you how to avoid repeating the processes which originally created the issues.
A slightly different approach to the above might be to identify the issues, instruct you how to cleanup the issues and then teach you how to avoid repeating the processes which originally created the issues.

What else can Quick Trainer do with regards to Training?
QuickBooks Implementation/Data File Setup
QuickBooks Consulting
QuickBooks Custom Reports

In Summary
Quick Trainer offers businesses the absolute best in QuickBooks Training. If you find yourself with more questions than you have answers with regards to QuickBooks and/or accounting; if you are facing some major confusion on the "how-to's" of QuickBooks and/or accounting, let Quick Trainer bring sound answers and solid solutions to your questions and confusion. The result for you will be clarity, peace of mind and QuickBooks success!