新足迹

 找回密码
 注册

精华好帖回顾

· 带着宠物去旅游-大洋路3日 (2010-4-5) thief · 三言两语 (2010-1-3) 飞儿
· 法国一年 (2012-10-9) cheersshan · 关于private health insurance (2004-12-17) astina
Advertisement
Advertisement
查看: 1257|回复: 9

[会计] Reconciliation遇到难题,熟悉Great Plain或者高人请帮忙,内附Great Plain回信~~~ [复制链接]

发表于 2011-2-17 17:30 |显示全部楼层
此文章由 Mushroom 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 Mushroom 所有!转贴必须注明作者、出处和本声明,并保持内容完整
Reconciliation是每天的功课,但这次遇到这种问题就比较奇怪。
我们用的是Great Plain,我像平时一样把要对账的当天(2月1号)的Bank statement里的adjustment entry都输进去,然后对照bank statement吧每一项tick了,但怎么就多出了一个outstanding 的amount。关键前一天的reconciliation已经等了,什么opening bal,closing bal也是对的。
打电话给Great Plain 的support,姐姐也是不太懂,我传了前后几天的bank statement和outstanding 的list给他,姐姐给我回了一封长信。绕来绕去,我晕了。有没有会计大人也遇到过这种情况,帮我解答一下。谢谢啦,希望大家可以共同学习!


Great Plain 的回信如下:
Hi
I appreciate your time on checking with 2nd of Feb reconciliation as well.  Since the Chequebook Balance from the Reconcile Balances window and Chequebook Balance Enquiry window, this means that there might be some issues with Outstanding Checks and Deposits in Transit.

Here are also more information about the fields and what they calculate:
1. Statement Ending: Displays the statement ending balance as entered in the Balance Reconcile Bank Statements window
2. Outstanding Checks(-): Displays the amount of checks, decrease adjustments or withdrawal transaction types that haven't been marked as cleared. The amount will be updated each time you mark or unmark one of these transaction types. This total will include outstanding transactions up to the cutoff date, if a cutoff date was entered.
3. Deposits in Transit(+): Displays the amount of deposits or increase adjustment transaction types that haven't been marked as cleared. The amount will be updated each time you mark or unmark one of these transaction types. This total will include outstanding transactions up to the cutoff date.
4. Adjusted Bank Balance: The calculation is: Statement Ending Balance - Outstanding Checks + Deposits in Transit. This amount will be recalculated when a transaction is marked or unmarked in the Select Bank Transactions window. This field is also displayed on the Select Bank Transactions window.
5. Checkbook Balance: as this amount is calculated by taking the current balance from as of cutoff the Checkbook Maintenance window plus checks after the cutoff date, minus deposits after the cutoff date.
6. Adjustments: Displays the net adjustments total from the Reconcile Bank Adjustments window.
7. Adjusted Book Balance: The calculation is the Checkbook balance as of cutoff date plus the Net Adjustment amount in the Reconcile Bank Adjustments window. This field is also displayed on the Select Bank Transactions window.
8. Difference: Displays the Adjusted Bank Balance minus the Adjusted Book Balance. The checkbook can be reconciled if this amount is zero. If the difference is not zero, you'll need to verify that the correct transactions were marked to clear and that all adjustments have been entered in the Reconcile Bank Adjustments window. This field is also displayed on the Select Bank Transactions window.


I have checked the cleared transactions from the Bank Statement against the Select Bank Transactions window and they matched.  Since this is match, we need to check on the Outstanding Checks and Deposits in Transit.  In setting the right expectations, this will be considered consulting and will be billable if you wish me to continue on comparing these documents.

You would want to go through all transactions entered on that day or after 31st of January.

[ 本帖最后由 Mushroom 于 2011-2-17 18:52 编辑 ]
Advertisement
Advertisement

发表于 2011-2-17 18:19 |显示全部楼层
此文章由 西瓜米米 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 西瓜米米 所有!转贴必须注明作者、出处和本声明,并保持内容完整
我们也用GP,不过我不是AA,不做REC...

发表于 2011-2-17 18:36 |显示全部楼层
此文章由 sunflowerseed 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 sunflowerseed 所有!转贴必须注明作者、出处和本声明,并保持内容完整
adjustment entry是不是输反向了。

发表于 2011-2-17 19:23 |显示全部楼层
此文章由 Mushroom 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 Mushroom 所有!转贴必须注明作者、出处和本声明,并保持内容完整
adjustment entry确定没有错,所以我和GP的support一起研究了很久也没想出头绪来。
还有没有同学给点idea~~~~~~~明天怎么办啊??

发表于 2011-2-17 20:53 |显示全部楼层

回复 4# 的帖子

此文章由 apclerk 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 apclerk 所有!转贴必须注明作者、出处和本声明,并保持内容完整
你有没有打电话给银行,看看银行方面有没有出错啊?  另外,还有别的情况可能你没有料到的,例如:以外的refund?有时候不是op. bal. 跟cl.bal.对得上就对吧?

发表于 2011-2-18 14:19 |显示全部楼层
此文章由 ellie乖乖 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 ellie乖乖 所有!转贴必须注明作者、出处和本声明,并保持内容完整
GL 与cheque book的balance一样吗?
Advertisement
Advertisement

发表于 2011-2-18 19:39 |显示全部楼层
此文章由 littlegirl 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 littlegirl 所有!转贴必须注明作者、出处和本声明,并保持内容完整
你把period选错了吧?你查查reconciliation date和你最后那天的bank statement data是一致的吗?

发表于 2011-2-19 13:55 |显示全部楼层
此文章由 sydney.tennis 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 sydney.tennis 所有!转贴必须注明作者、出处和本声明,并保持内容完整
Cancelled cheque?

发表于 2011-2-21 08:18 |显示全部楼层
此文章由 neverif 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 neverif 所有!转贴必须注明作者、出处和本声明,并保持内容完整
ask for screen share session吧,support姐姐?是不是Marian?赫赫

发表于 2011-2-21 21:01 |显示全部楼层
此文章由 Tigerpie 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 Tigerpie 所有!转贴必须注明作者、出处和本声明,并保持内容完整
检查一下是不是2月1号以后的交易过账到2月1号以前了,如果确定没有,说不定是voiding cheque出了问题,软件的Bug.

发表回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则

Advertisement
Advertisement
返回顶部