Microsoft Excel can be used to extract data from different Financial and Accounting Systems and import that data into
this Accounting Reporting System, to use the Reports Summaries, Reports Details & Graphs and Audits.
Fields Required:
1) Date
2) Amount
3) Group-Income-Or-Expense
4) Fund ADM, CW (Administration-Capital-Works)
5) Description
6) Type: Income-Or-Expenses
ACCOUNTING REPORTING SYSTEM
Advanced and Powerful Reporting for Accounting, Investing, Stocktaking and many other Uses
Business Organizations of All Sizes and Types – Large, Medium, Small – For All Age Groups
Provides Reports and Summaries – 12 Years, 12 Months – Charts and Multiple Detailed Audits
No Limits on Years, Historical Data Volume, or Analytical Depth and Audit Details Reports
The data fields from Microsoft Excel must be in the same order and type as it is on the Accounting Reporting System.
1) Import from Microsoft Excel the 6 fields showed in the RED line using CTRL C keys (COPY)
2) Export into Accounting Reporting System Window-3 using ..................... CTRL V keys (PASTE)
3) After Steps 1 & 2 the 6 fields will be in the Accounting Reporting System. Show in RED line.
4) Click the 'Refresh Calculation' button to summarize the transactions and verify and/or check the totals.
5) Click the 'UPDATE ACTUAL DATA' button to add the data to the Database Project.
How to use COPY and PASTE: CTRL C keys - CTRL V keys - Will COPY and PASTE. Unlimited number of records.
1) Copy from Excel: Click on the first line, first field you want to Start Import
2) Copy from Excel: Hold down the SHIFT key THEN Click on the last line and last field you want to End Import
3) Paste into Accounting Reporting: Click on the first line, first field only and the data will be automatically imported.
Reports Summaries with Data Integrity FDGDATABASE@HOTMAIL.COM Reports Details with Audits Tools