Breeze Accountants Worksheet -
Video Tutorial
All videos are in "avi"
format and can be downloaded in a self extracting zip file for viewing on
your machine. An "avi" file viewer is required.
Basic Editing
The Basic Editing
tutorial covers:
-
Basic Editing in the Data Grid.
-
Adding Companies,Departments
and General Ledger Accounts.
-
Set Active Company ID.
-
Editing General Ledger Account
Balances.
-
Deleting Records in the Data grid.
- Validate and Save Record in the
Data Grid.
- Save File.
- Sort by Column.
- Primary Sort.
- Format Options; Freeze Columns,
Alias Comparative Balances, and Global Views.
Download Basic Editing
Tutorial
Import from an
Excel Exported Trial Balance
The Import tutorials use
the Simply Accounting and Quickbooks Excel exported Trial Balance reports
that are included in Sample Files. The Simply Accounting data is imported
into Company ID = 1, Department ID = 0. The Quickbooks data is imported into
Company ID = 2, Department ID = 0.
For each Import:
-
The Sum Column is
turned on and the Amount column is checked to balance to zero after
Preview.
-
The Has Errors and
Status columns are checked after the Import is run.
-
After closing the
Import Form, the Sum Column is turned on and the selected Amount
Field. [UnAdjusted Balance] is checked to balance to zero.
-
An Adjusted Trial
Balance is then run to verify the imported data.
Download Import Tutorials
Copy
GL Assignments
The
Copy GL Assignments tutorial covers:
- Copying General Ledger Account
Assignments; Type, Statement and Normal Sign.
- The General Ledger Worksheet
Balance Sheet.
- The General Ledger Worksheet
Income Statement.
Download Copy GL
Assignments Tutorial
GL Block
Account Changes
The GL
Block Account Changes tutorial covers:
- Copying General Ledger Accounts
from one Department to another using Block Account Changes.
- Filtering the General ledger
Worksheet.
- Filtering for a General Ledger
Worksheet Report.
- Using Block Account Changes to
Delete a block of General Ledger Worksheet Accounts.
Download GL Block
Account Changes Tutorials
Adjustments
The Adjustments Tutorial covers:
- Adding Adjustments.
- Editing Header and Detail records
in an Adjustment.
- Selecting accounts from the
General Ledger Accounts List.
- Adjustments Journal Report.
Download Adjustments Tutorial
Reclassifieds and Transaction
List
The Reclassifieds and Transaction List
Tutorials covers:
- Adding Reclassifieds.
- Grouping individual Reclassifieds
entries.
- Using the Transaction List to
drill down.
Download Reclassifieds and Transaction List
Financial Statements Accounts
The Financial Statement Accounts Tutorials
Covers:
- Adding Financial Statement
Groups.
- Adding Financial Statement
Accounts.
- Assigning a Financial Statement
Account to a Financial Statement Group.
- Assigning a General Ledger Account
to a Financial Statement Account.
- Set filter prior to
Calculate Financial Statement
Accounts.
- Calculate Financial Statement
Accounts.
- The Financial Statement Account
Assembly Report.
- Using Sum Column to Balance the
Calculated Financial Statement Accounts to zero.
- The Financial Statement Account
Adjusted Trial Balance Report.
- Draft Balance Sheet of Financial
Statement Accounts.
Download
Financial Statement Accounts Tutorial
XL Template
The XL Template Tutorials cover:
- Creating a New XL Template.
- Connecting to a Breeze Accountants
Worksheet database file.
- Creating Custom Formulas with the
user defined functions in Excel
- Using the BAW_Lookup function in
Excel.
- Using the BAW_Sum function in
Excel.
- Copying and Editing Custom
Formulas in Excel.
- Post Calculated Columns in General
Ledger Worksheet.
- Recalculate XL Template.
Download XL Template
Tutorial 1
Download XL Template
Tutorial 2
