AR Balance & Prepayment account

Yahoo Archive
1
I remember what our mess up was when we first started applying cash... have you ever had unapplied cash... we did once the first couple of months and it actually put the word "error" on the je.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of how2wow
Sent: Tuesday, February 21, 2006 2:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AR Balance & Prepayment account


I am comparing the GL to the aging, which I run by fiscal period.

The opening GL balance matched the AR aging when we converted. Since
then, it has gone haywire. It is off a different amount every month,
which suggests it has something to do with the dating.

I have run the adjustments journal to check for any oddball postings
the either the AR or prepayment account. I am convinced it has
something to do with the prepayment account and the dating- not
necessarily the GL being wrong, but possibly the aging report not
picking something up.
--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...> wrote:
>
> I use a set of reconciliation formats to look to see where the
problem might be... in the detail or in the General Ledger. Are you
using something like this or are you just comparing totals with totals?






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links








______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
2
We went live 9/1. I have not been able to tie out the aging with my
GL balances since then. All the invoices that we brought over foot.

I am taking the GL balances of A/R and prepayment combined and running
the aging by fiscal period.

Could this be some kind of timing/date issue? I'm running out of
ideas...
3
Did you balance on 09/01?

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of how2wow
Sent: Monday, February 20, 2006 2:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] AR Balance & Prepayment account


We went live 9/1. I have not been able to tie out the aging with my
GL balances since then. All the invoices that we brought over foot.

I am taking the GL balances of A/R and prepayment combined and running
the aging by fiscal period.

Could this be some kind of timing/date issue? I'm running out of
ideas...



[Non-text portions of this message have been removed]
4
Yes.

--- In vantage@yahoogroups.com, "Frances Skidmore" <Frances@...>
wrote:
>
> Did you balance on 09/01?
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of how2wow
> Sent: Monday, February 20, 2006 2:47 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] AR Balance & Prepayment account
>
>
> We went live 9/1. I have not been able to tie out the aging with
my
> GL balances since then. All the invoices that we brought over
foot.
>
> I am taking the GL balances of A/R and prepayment combined and
running
> the aging by fiscal period.
>
> Could this be some kind of timing/date issue? I'm running out of
> ideas...
>
>
>
> [Non-text portions of this message have been removed]
>
5
I have found that if I am off on any of my accounts I go back to the
month that all was in balance and print the GL in detail and aged
receivables for each month until I find the culprit. My culprit was I
had posted a payment in the wrong year in December. Hope this helps.

Frances Skidmore
Entek Corporation

Yes.

--- In vantage@yahoogroups.com, "Frances Skidmore" <Frances@...>
wrote:
>
> Did you balance on 09/01?
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of how2wow
> Sent: Monday, February 20, 2006 2:47 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] AR Balance & Prepayment account
>
>
> We went live 9/1. I have not been able to tie out the aging with
my
> GL balances since then. All the invoices that we brought over
foot.
>
> I am taking the GL balances of A/R and prepayment combined and
running
> the aging by fiscal period.
>
> Could this be some kind of timing/date issue? I'm running out of
> ideas...
>
>


[Non-text portions of this message have been removed]
6
Have you rerun your sales journal and cash receipt journal to make sure they
still match from when they were run at month end? Check G/L account tracker
and look at the post dates. Has anything been posted in those months that
was dated either earlier or later? Are they any journal entries or
adjustments that are hitting the account?

Jim
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Frances Skidmore
Sent: Tuesday, February 21, 2006 11:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: AR Balance & Prepayment account


I have found that if I am off on any of my accounts I go back to the
month that all was in balance and print the GL in detail and aged
receivables for each month until I find the culprit. My culprit was I
had posted a payment in the wrong year in December. Hope this helps.

Frances Skidmore
Entek Corporation

Yes.

--- In vantage@yahoogroups.com, "Frances Skidmore" <Frances@...>
wrote:
>
> Did you balance on 09/01?
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of how2wow
> Sent: Monday, February 20, 2006 2:47 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] AR Balance & Prepayment account
>
>
> We went live 9/1. I have not been able to tie out the aging with
my
> GL balances since then. All the invoices that we brought over
foot.
>
> I am taking the GL balances of A/R and prepayment combined and
running
> the aging by fiscal period.
>
> Could this be some kind of timing/date issue? I'm running out of
> ideas...


[Non-text portions of this message have been removed]
7
I use a set of reconciliation formats to look to see where the problem might be... in the detail or in the General Ledger. Are you using something like this or are you just comparing totals with totals?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Jim Frice
Sent: Tuesday, February 21, 2006 12:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: AR Balance & Prepayment account


Have you rerun your sales journal and cash receipt journal to make sure they
still match from when they were run at month end? Check G/L account tracker
and look at the post dates. Has anything been posted in those months that
was dated either earlier or later? Are they any journal entries or
adjustments that are hitting the account?

Jim
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Frances Skidmore
Sent: Tuesday, February 21, 2006 11:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: AR Balance & Prepayment account


I have found that if I am off on any of my accounts I go back to the
month that all was in balance and print the GL in detail and aged
receivables for each month until I find the culprit. My culprit was I
had posted a payment in the wrong year in December. Hope this helps.

Frances Skidmore
Entek Corporation

Yes.

--- In vantage@yahoogroups.com, "Frances Skidmore" <Frances@...>
wrote:
>
> Did you balance on 09/01?
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of how2wow
> Sent: Monday, February 20, 2006 2:47 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] AR Balance & Prepayment account
>
>
> We went live 9/1. I have not been able to tie out the aging with
my
> GL balances since then. All the invoices that we brought over
foot.
>
> I am taking the GL balances of A/R and prepayment combined and
running
> the aging by fiscal period.
>
> Could this be some kind of timing/date issue? I'm running out of
> ideas...


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links







______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
8
I am comparing the GL to the aging, which I run by fiscal period.

The opening GL balance matched the AR aging when we converted. Since
then, it has gone haywire. It is off a different amount every month,
which suggests it has something to do with the dating.

I have run the adjustments journal to check for any oddball postings
the either the AR or prepayment account. I am convinced it has
something to do with the prepayment account and the dating- not
necessarily the GL being wrong, but possibly the aging report not
picking something up.
--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...> wrote:
>
> I use a set of reconciliation formats to look to see where the
problem might be... in the detail or in the General Ledger. Are you
using something like this or are you just comparing totals with totals?
9
You talked about prepays. What are the dates on some of the prepays? If they
are in the future they probably aren't going to be on the aging but they are
in the GL figure.

Jim
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
how2wow
Sent: Tuesday, February 21, 2006 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AR Balance & Prepayment account


I am comparing the GL to the aging, which I run by fiscal period.

The opening GL balance matched the AR aging when we converted. Since
then, it has gone haywire. It is off a different amount every month,
which suggests it has something to do with the dating.

I have run the adjustments journal to check for any oddball postings
the either the AR or prepayment account. I am convinced it has
something to do with the prepayment account and the dating- not
necessarily the GL being wrong, but possibly the aging report not
picking something up.
--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...> wrote:
>
> I use a set of reconciliation formats to look to see where the
problem might be... in the detail or in the General Ledger. Are you
using something like this or are you just comparing totals with totals?






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



SPONSORED LINKS Manufacturing software Membership database software
Database mortgage software
Pda database software Database management software Database
marketing software


----------------------------------------------------------------------------
--
YAHOO! GROUPS LINKS

a.. Visit your group "vantage" on the web.

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.


----------------------------------------------------------------------------
--



[Non-text portions of this message have been removed]
10
Here is the rec that I use for AR - You use the totals from the G/LDistribution report. Checking first the Sales then getting the total for your A/R #, Then run it again using Cash Receipts getting the total for your A/R #, Then again to see if you have any adjustments for your A/R # Then you compare the begining to the ending with these ins and outs. Then it compares the total to GL balance. This way you have an idea on where to start looking.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of how2wow
Sent: Tuesday, February 21, 2006 2:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AR Balance & Prepayment account


I am comparing the GL to the aging, which I run by fiscal period.

The opening GL balance matched the AR aging when we converted. Since
then, it has gone haywire. It is off a different amount every month,
which suggests it has something to do with the dating.

I have run the adjustments journal to check for any oddball postings
the either the AR or prepayment account. I am convinced it has
something to do with the prepayment account and the dating- not
necessarily the GL being wrong, but possibly the aging report not
picking something up.
--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...> wrote:
>
> I use a set of reconciliation formats to look to see where the
problem might be... in the detail or in the General Ledger. Are you
using something like this or are you just comparing totals with totals?






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links








______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________


[Non-text portions of this message have been removed]