Importing Trial Balance Data (2:10)
MP4
YouTube
Trial balance data from accounting software
Importing Budget Trial Balance data
Importing Trial Balance Data / QuickBooks Desktop (1:31)
ExcelFSM with the QuickBooks Desktop optional feature (check option
before 'Download') has direct access to QuickBooks Company data file.
Suggestion: set QuickBooks Preferences to _Show lowest subaccount only
Importing Budget Trial Balance data
Working with QuickBooks Accountant’s Copy file
Importing Trial Balance Data / QuickBooks Online (0:41)
ExcelFSM with the QuickBooks Online optional feature (check option
before 'Download') has direct access to QuickBooks Company data file.
Creating the FSM QBOnline company file (1:05)
Resetting the FSM QBOnline company file (0:22)
Importing Budget Trial Balance data
How to prepare Periodic financial reports [Monthly,Quarterly,etc.]
(Click image to see how)
Notes And Reports
(Click image to see how)
How to prepare a Financial Summary Report and how to access already grouped accounts for grouping into other items
(Click image to see how)
How to build a trial balance working paper showing the consolidated adjusted trial balances side by side
(Click image to see how)
Building A Financial Statement (10:37)
MP4
YouTube
Updating Financial Statements (2:39)
MP4
YouTube
Building A Statement Of Cash Flows (8:33)
MP4
YouTube
ExcelFSM Working Papers (4:30)
MP4
YouTube
Consolidated Financial Statements (9:23) (muted video)
MP4
ExcelFSM allows to group accounts from different trial balances into financial statement items, using simple point and click on the screen.
How to prepare a Quick Report showing Financial Key Figures
(Click image to see how)
How ExcelFSM Handles QuickBooks Classes
(Click image to see how)
How to prepare a multiple columns report
(Click image to see how)
How to easily prepare a Cash Flow Statement
(Click image to see how)
How to prepare a financial statement with item balances on
two columns, and
how to access any item balance for grouping into tolals
(Click image to see how)
