金蝶KIS专业版Excel格式凭证导入工具
本帖最后由 uctayvii 于 2020-8-29 11:30 编辑[*]先按标准模板整好要导入的凭证,利用此工具转换成金蝶标准格式
[*]登录进入金蝶财务软件，点击页面左边的账务处理。
[*]https://exp-picture.cdn.bcebos.com/f0848bee41c1b7278570d53c1a2ca5cadde898bb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
[*]
进入账务处理模块，点击凭证管理。
https://exp-picture.cdn.bcebos.com/76b6860e5f2043716bf8e594323acd8921c58fbb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
[*]
页面跳转，点击文件，在弹出的选项中点击引入标准凭证。
页面弹出引入标准凭证对话框，点击下一步。
https://exp-picture.cdn.bcebos.com/589f5b07880138709562e9382d08a50f95fc83bb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
https://exp-picture.cdn.bcebos.com/9a8fd9f88a775dddc26f36fea427e7ef2906f9bb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
[*]
选择excel文件放置的路径，点击下一步。
选择引入凭证的日期范围，再点击下一步。
如果需要全部引入，则直接点击下一步就可以了。
https://exp-picture.cdn.bcebos.com/3201a8f39187031ccce37c486a86242fa972ecbb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
https://exp-picture.cdn.bcebos.com/256eb672941fbee468f923eac1237971ff1de7bb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
[*]
进入凭证引入第三步，直接点击下一步。
页面跳转，进入第四步，点击开始引入，再点击下一步。
https://exp-picture.cdn.bcebos.com/979906196120a7cd694d284689b375d7987bdcbb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
https://exp-picture.cdn.bcebos.com/983aa5f4da5872dab36ab2bb0056ad042f68d4bb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
[*]
开始引入凭证，页面会弹出正在引入的进度条，进度条读完之后，点击下一步。
凭证引入完毕之后，点击关闭。
https://exp-picture.cdn.bcebos.com/2f2909e951e10ef82d7506892324d8e9cdd2ccbb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
https://exp-picture.cdn.bcebos.com/cd93a566515985406d09d756b5a23a42a17ac4bb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
[*]
页面自动返回到凭证管理界面，点击刷新，就可以看到引入的excel会计凭证了。
https://exp-picture.cdn.bcebos.com/a151a233ec3834bb9fcc71eb8714c27bd3823db8.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
https://exp-picture.cdn.bcebos.com/c33acc828689a1463a923d4df4bd4c7c35b334b8.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1
页:
[1]
2