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