Home AP4.0 User Manual – Table of Contents AP4.0 User Manual – 12. Appendices AP4.0 User Manual – 12.6 Appendices F Instructions on Using Ledger Extraction Tools

Audit Program 4.0 - User Manual

Appendices

Export the Detailed Trial Balance from ABSS / MYOB
Rename the exported Excel workbook as “Ledgers.xlsx”
Place the renamed workbook in the same file path / folder as this “Extraction Tool” file
Click the button “Extract Ledgers”
The extracted ledgers for each worksheet in “Ledger.xlsx” will be saved as a new excel file in the folder “Extracted Ledgers”
Copy all files in “Extracted Ledgers” and move them to the folder named “Ledger” in the client’s folder that you are working on.

Export the Ledger from PeachTree
Rename the exported Excel workbook as “Ledgers.xlsx”
Place the renamed workbook in the same file path / folder as this “Extraction Tool” file
Click the button “Extract Ledgers”
The extracted ledgers for each worksheet in “Ledger.xlsx” will be saved as a new excel file in the folder “Extracted Ledgers”
Copy all files in “Extracted Ledgers” and move them to the folder named “Ledger” in the client’s folder that you are working on.

Export the General Ledger from MasterSoft
Rename the exported Excel workbook as “Ledgers.xlsx”, and Rename the worksheet for General ledger as “General ledger”
Place the renamed workbook in the same file path / folder as this “Extraction Tool” file
Click the button “Extract Ledgers”
The extracted ledgers for each worksheet in “Ledger.xlsx” will be saved as a new excel file in the folder “Extracted Ledgers”
Copy all files in “Extracted Ledgers” and move them to the folder named “Ledger” in the client’s folder that you are working on.

Export the 明细分类账 from KingDee / 金蝶
Rename the exported Excel workbook as “Ledgers.xlsx”
Place the renamed workbook in the same file path / folder as this “Extraction Tool” file
Click the button “Extract Ledgers”
The extracted ledgers for each worksheet in “Ledger.xlsx” will be saved as a new excel file in the folder “Extracted Ledgers”
Copy all files in “Extracted Ledgers” and move them to the folder named “Ledger” in the client’s folder that you are working on.

Export the Ledger from Manager io
Rename the exported Excel workbook as “Ledgers.xlsx”
Place the renamed workbook in the same file path / folder as this “Extraction Tool” file
Click the button “Extract Ledgers”
The extracted ledgers for each worksheet in “Ledger.xlsx” will be saved as a new excel file in the folder “Extracted Ledgers”
Copy all files in “Extracted Ledgers” and move them to the folder named “Ledger” in the client’s folder that you are working on.

Export the 序时账 from 浪潮
Rename the exported Excel workbook as “Ledgers.xls”
Open Ledgers.xls and select only column G (方向）, press Ctrl + F and replace all 借 with “Debit”, then save changes
Place the renamed “Ledgers.xls” workbook in the same file path / folder as this “Extraction Tool” file
Click the button “Extract Ledgers”
The extracted ledgers for each account in “Ledgers.xls” will be saved as a new excel file in the folder “Extracted Ledgers”
Copy all files in “Extracted Ledgers” and move them to the folder named “Ledger” in the client’s folder that you are working on.

Export the 序时账 from 财务云
Rename the exported Excel workbook as “Ledgers.xlsx”
Place the renamed “Ledgers.xlsx” workbook in the same file path / folder as this “Extraction Tool” file
Click the button “Extract Ledgers”
The extracted ledgers for each account in “Ledgers.xlsx” will be saved as a new excel file in the folder “Extracted Ledgers”
Copy all files in “Extracted Ledgers” and move them to the folder named “Ledger” in the client’s folder that you are working on.