Reconciling the A/P Clearing Account

Deb, the $ amount isn't all that large so as you say, not much harm is done.
However, it goes to WIP anyway and doesn't affect the financials. You can go
ahead and clear those invoices in the previous month so that those
miscellaneous charges will be entered in the correct month, but your AP
person will have to be very careful about keeping the report in order.

We have several reports that must be ran before any activity for the new
month takes place. Inspection Pending is another report that can be time
consuming and frustrating to balance but as long as it is ran on the 1st of
the month before any activity takes place, it should balance with the GL.

I would also like to see reports that accurately reflect the period asked
for. Thanks for the feedback.

Karen Brodniak
Accounting Manager
Phone: 425-742-7011 x44
Fax: 425-353-8945
karen.brodniak@...

-----Original Message-----
From: Wilmoth, Deb [mailto:Deb@...]
Sent: Wednesday, August 29, 2001 2:27 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Reconciling the A/P Clearing Account

Karen, I can see how this would work. However, then A/P is understated for
all the miscellaneous charges (freight, taxes, lot charges, cert fees, etc.)
attributable to those invoices in the previous month. IF those are not
large $ amounts, not much harm is done. It is rotten to have to make work
arounds and pick the lesser of the evils. I would prefer to see the
programming changed OR reports that accurately reflects the period so that
reconciling all balance sheet accounts is possible.

-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Monday, August 27, 2001 10:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Reconciling the A/P Clearing Account


Yes, I reconcile the A/P Clearing each month to the penny. The key to
getting the "Received but not Invoiced" report to match the GL is to run the
report on the 1st of the month before any AP activity has been recorded.
What happens is that if you do not run the report and clear an invoice in
the month you are actually in, that invoice disappears off the report, even
though it was still in clearing at the previous month's end. Once an invoice
is cleared, it is gone off the report, not matter what day you run the
receipt date to. To avoid confusion and backtracking to make the report
match, we run the report on the first and don't clear any invoices in the
previous month.

Karen Brodniak
Accounting Manager
karen.brodniak@...



[


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




Yahoo! Groups Sponsor
ADVERTISEMENT




You can, too! Start here...

Height:
3 4 5 6 7 8 ft 0 1 2 3 4 5 6 7 8 9 10 11 in

Weight:
lbs. kg.








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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


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

1. Do you reconcile the A/P Clearing Account G/L balance to the Received
but Not Invoiced Report each month?

2. If so, do you reconcile to the penny or just "close enough"?




[Non-text portions of this message have been removed]
I reconcile the A/P clearing account at year-end against my uninvoiced
receiving paperwork.

-----Original Message-----
From: Wilmoth, Deb [SMTP:Deb@...]
Sent: Friday, August 24, 2001 11:01 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Reconciling the A/P Clearing Account

Accounting Survey:

1. Do you reconcile the A/P Clearing Account G/L balance to the Received
but Not Invoiced Report each month?

2. If so, do you reconcile to the penny or just "close enough"?




[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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Close enough.

Alex Neutgens
Controller
Circuit Check, Inc.
Phone 763-694-4110
Fax 763-694-4151

-----Original Message-----
From: Wilmoth, Deb [SMTP:Deb@...]
Sent: Friday, August 24, 2001 11:01 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Reconciling the A/P Clearing Account

<< File: ATT00028.htm >>
We reconcile every month to the penny. Very rarely is it off. But if it
is, it's easy to find because you only have to look at one months
transactions.

Kathy Hambleton
Electron Energy Corporation



-----Original Message-----
From: Wilmoth, Deb [mailto:Deb@...]
Sent: Friday, August 24, 2001 12:01 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Reconciling the A/P Clearing Account


Accounting Survey:

1. Do you reconcile the A/P Clearing Account G/L balance to the Received
but Not Invoiced Report each month?

2. If so, do you reconcile to the penny or just "close enough"?
What is the sales volume of your company?

-----Original Message-----
From: Kathy Hambleton [mailto:kbh@...]
Sent: Friday, August 24, 2001 2:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Reconciling the A/P Clearing Account


We reconcile every month to the penny. Very rarely is it off. But if it
is, it's easy to find because you only have to look at one months
transactions.

Kathy Hambleton
Electron Energy Corporation



-----Original Message-----
From: Wilmoth, Deb [mailto:Deb@...]
Sent: Friday, August 24, 2001 12:01 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Reconciling the A/P Clearing Account


Accounting Survey:

1. Do you reconcile the A/P Clearing Account G/L balance to the Received
but Not Invoiced Report each month?

2. If so, do you reconcile to the penny or just "close enough"?







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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Yes, I reconcile the A/P Clearing each month to the penny. The key to
getting the "Received but not Invoiced" report to match the GL is to run the
report on the 1st of the month before any AP activity has been recorded.
What happens is that if you do not run the report and clear an invoice in
the month you are actually in, that invoice disappears off the report, even
though it was still in clearing at the previous month's end. Once an invoice
is cleared, it is gone off the report, not matter what day you run the
receipt date to. To avoid confusion and backtracking to make the report
match, we run the report on the first and don't clear any invoices in the
previous month.

Karen Brodniak
Accounting Manager
karen.brodniak@...

-----Original Message-----
From: Wilmoth, Deb [mailto:Deb@...]
Sent: Friday, August 24, 2001 9:01 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Reconciling the A/P Clearing Account

Accounting Survey:

1. Do you reconcile the A/P Clearing Account G/L balance to the Received
but Not Invoiced Report each month?

2. If so, do you reconcile to the penny or just "close enough"?




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




Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17050071
83:HM/A=763786/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-4458-1039-1?mpt=
998668915>


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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
If you donÂ’t look at your past receipts you will never know you have old
items out, that have not been invoiced against. If you make sure that all
receivers are cleared against an invoice from the time you started doing
receivers. If you started using receivers and didnÂ’t integrate receivers
with AP from the beginning you will have a lot of old receivers that will
need to be cleared. This can be quite time consuming, but is well worth the
work to ensure future data integrity. Then when you run the Received but
not Invoice Report you can start at the beginning of the current year to the
present month end and will know if something has slipped by you. Believe me
someone will enter a receiver with a past date and it can cause a variety of
balancing issues. Also many companies start entering AP invoices for the
new period before they have finished entering for the last period. All of
these things should be taken into consideration. No matter how careful the
person doing receiving is somewhere along the line something will be
received wrong and it cannot be backed out and re-received. Of course this
will not be discovered until an unspecified period of time has passed, which
just makes the problem worse.

-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Monday, August 27, 2001 08:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Reconciling the A/P Clearing Account

Yes, I reconcile the A/P Clearing each month to the penny. The key to
getting the "Received but not Invoiced" report to match the GL is to run the
report on the 1st of the month before any AP activity has been recorded.
What happens is that if you do not run the report and clear an invoice in
the month you are actually in, that invoice disappears off the report, even
though it was still in clearing at the previous month's end. Once an invoice
is cleared, it is gone off the report, not matter what day you run the
receipt date to. To avoid confusion and backtracking to make the report
match, we run the report on the first and don't clear any invoices in the
previous month.

Karen Brodniak
Accounting Manager
karen.brodniak@...

-----Original Message-----
From: Wilmoth, Deb [mailto:Deb@...]
Sent: Friday, August 24, 2001 9:01 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Reconciling the A/P Clearing Account

Accounting Survey:

1. Do you reconcile the A/P Clearing Account G/L balance to the Received
but Not Invoiced Report each month?

2. If so, do you reconcile to the penny or just "close enough"?




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




Yahoo! Groups Sponsor

<
http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17050071
83:HM/A=763786/R=0/*
http://altfarm.mediaplex.com/ad/ck/1177-4458-1039-1?mpt=
998668915>


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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/> .


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




Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=207641.1565480.3121573.1269402/D=egroupweb/S=17050071
83:HM/A=765263/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b15334027000300
0>


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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
At 11:32 AM 8/27/2001 , you wrote:
>The key to getting the "Received but not Invoiced" report to match the GL
>is to run the report on the 1st of the month before any AP activity has
>been recorded.

On a related note... I recently discovered our Accounting Dept has been
entering large adjusting J.E.s every month end based on reports using stale
data, just as you mentioned. They assumed bugs in Vantage were causing
the drifting dollar amounts every month, and just did this as part of the
routine (our pre-Vantage software did require this.)

I got wind of this at last month end when they asked the production depts
to suspend all data entry into Vantage on the morning of the 1st! They had
figured out where the "drift" might be coming from, but didn't think to ask
me if there was any better solution.

Me: "Hey, guys - you know next month I could take the backup from the 31st
and let you access that, just like our testing / implementation DB. Then
you'd have the month end data frozen for as long as you'd like."
Them: "Wow! You mean we wouldn't have to come in at 5:00am and kick every
one out of Vantage all morning?!"

If only more things were that easy :) Can't wait to see if all the
right dollars are in the right accounts *All By Themselves* in Sept. (nah
- on 2nd thought, I can wait till Tues!)

-Wayne Cox
Don't count on it.

From an accounting standpoint, Vantage is programmed in a very peculiar way.
Hence, my question to the group on how many people reconcile the A/P
Clearing Account to the penny. Or try to anyway.

We do not EVER have all our prior month invoices processed by the first on
the month. It is impossible to have the invoices on the first for
merchandise received on the 30th or 31st. The US Postal Service will never
get THAT good. However, following GAAP, that merchandise belongs in the
prior month, when it was received, as do the invoice and extra costs
associated with it (like sales tax or freight or Cert fees, etc).

The processing of Vantage will post those extra costs to the month the
invoice is processed (let's say August), not when received (let's say
Sept.), even though an August group is used for the A/P invoice and the
invoice is correctly entered with its August date. The processing of the
invoice creates a debit in the A/P Clearing Account and credits A/P for
August so that A/P is correct, but not the A/P Clearing Account. This
creates a reconciliation problem in the A/P Clearing Account.

Once the truant invoices are identified, an adjusting G/L entry is easy
enough to make (but why program Vantage to create the extra work!?!?!).
However, finding those entries is the problem that takes way too much time
and drudge work (the accounting equivalent for a slide rule) for an
integrated system like Vantage.

This description is a very breviated, condensed version of the problem with
the way miscellaneous charges are handled in Vantage. I view the problem
as even worse when tying those extra costs to the line item instead of the
header since unwanted variances are created. It is my latest and greatest
crusade in Vantage programming changes. My $.02 worth on a frustrating
matter. I know, I know. Just ignore GAAP and change the way we do
business!!!!!

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Monday, August 27, 2001 11:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Reconciling the A/P Clearing Account


At 11:32 AM 8/27/2001 , you wrote:
>The key to getting the "Received but not Invoiced" report to match the GL
>is to run the report on the 1st of the month before any AP activity has
>been recorded.

On a related note... I recently discovered our Accounting Dept has been
entering large adjusting J.E.s every month end based on reports using stale
data, just as you mentioned. They assumed bugs in Vantage were causing
the drifting dollar amounts every month, and just did this as part of the
routine (our pre-Vantage software did require this.)

I got wind of this at last month end when they asked the production depts
to suspend all data entry into Vantage on the morning of the 1st! They had
figured out where the "drift" might be coming from, but didn't think to ask
me if there was any better solution.

Me: "Hey, guys - you know next month I could take the backup from the 31st
and let you access that, just like our testing / implementation DB. Then
you'd have the month end data frozen for as long as you'd like."
Them: "Wow! You mean we wouldn't have to come in at 5:00am and kick every
one out of Vantage all morning?!"

If only more things were that easy :) Can't wait to see if all the
right dollars are in the right accounts *All By Themselves* in Sept. (nah
- on 2nd thought, I can wait till Tues!)

-Wayne Cox




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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



[Non-text portions of this message have been removed]
No I do not believe we should ignore GAAP and change the way we do business,
but this problem exists with most manufacturing software. It is as if
accounting exists and manufacturing is in another world. That should not be
the case. I have worked in only one other system where the transactions
from manufacturing, receiving, shipping, AR & AP are treated as if they are
part of the whole system and end up where they belong. We should continue
to ask Epicor to make these changes.

-----Original Message-----
From: Wilmoth, Deb [mailto:Deb@...]
Sent: Tuesday, August 28, 2001 07:34 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Reconciling the A/P Clearing Account

Don't count on it.

From an accounting standpoint, Vantage is programmed in a very peculiar way.
Hence, my question to the group on how many people reconcile the A/P
Clearing Account to the penny. Or try to anyway.

We do not EVER have all our prior month invoices processed by the first on
the month. It is impossible to have the invoices on the first for
merchandise received on the 30th or 31st. The US Postal Service will never
get THAT good. However, following GAAP, that merchandise belongs in the
prior month, when it was received, as do the invoice and extra costs
associated with it (like sales tax or freight or Cert fees, etc).

The processing of Vantage will post those extra costs to the month the
invoice is processed (let's say August), not when received (let's say
Sept.), even though an August group is used for the A/P invoice and the
invoice is correctly entered with its August date. The processing of the
invoice creates a debit in the A/P Clearing Account and credits A/P for
August so that A/P is correct, but not the A/P Clearing Account. This
creates a reconciliation problem in the A/P Clearing Account.

Once the truant invoices are identified, an adjusting G/L entry is easy
enough to make (but why program Vantage to create the extra work!?!?!).
However, finding those entries is the problem that takes way too much time
and drudge work (the accounting equivalent for a slide rule) for an
integrated system like Vantage.

This description is a very breviated, condensed version of the problem with
the way miscellaneous charges are handled in Vantage. I view the problem
as even worse when tying those extra costs to the line item instead of the
header since unwanted variances are created. It is my latest and greatest
crusade in Vantage programming changes. My $.02 worth on a frustrating
matter. I know, I know. Just ignore GAAP and change the way we do
business!!!!!

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Monday, August 27, 2001 11:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Reconciling the A/P Clearing Account


At 11:32 AM 8/27/2001 , you wrote:
>The key to getting the "Received but not Invoiced" report to match the GL
>is to run the report on the 1st of the month before any AP activity has
>been recorded.

On a related note... I recently discovered our Accounting Dept has been
entering large adjusting J.E.s every month end based on reports using stale
data, just as you mentioned. They assumed bugs in Vantage were causing
the drifting dollar amounts every month, and just did this as part of the
routine (our pre-Vantage software did require this.)

I got wind of this at last month end when they asked the production depts
to suspend all data entry into Vantage on the morning of the 1st! They had
figured out where the "drift" might be coming from, but didn't think to ask
me if there was any better solution.

Me: "Hey, guys - you know next month I could take the backup from the 31st
and let you access that, just like our testing / implementation DB. Then
you'd have the month end data frozen for as long as you'd like."
Them: "Wow! You mean we wouldn't have to come in at 5:00am and kick every
one out of Vantage all morning?!"

If only more things were that easy :) Can't wait to see if all the
right dollars are in the right accounts *All By Themselves* in Sept. (nah
- on 2nd thought, I can wait till Tues!)

-Wayne Cox




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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



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




Yahoo! Groups Sponsor
ADVERTISEMENT
Lose 20 lbs by November 5th!
<http://rd.yahoo.com/M=210544.1579977.3132570.1261774/D=egroupweb/S=17050071
83:HM/A=776677/R=0/*http://ads.track-star.com/adspace.ts?ts=1;2;217;107_222_
105_264%20>


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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
I can probably help you a little with the problem of invoiceing from the
prior month after you have printed your AP aging. This also applies to
many other reconciliation issues relating to backdating to the prior month.
You can make a report where the posted (actual) date is after the date you
run your aging. The aging plus this custom report should equal the GL
balance. Unfortunately there is not a posted time field to run a report
against. We don't allow backdating on the day we run our aging report.
For example. Run the aging on the first of the month. Make the custom
report list all transactions with a posted date greater than the first of
the month. It works fairly well for us and the auditors.

Alex Neutgens
Controller
Circuit Check, Inc.
763-694-4110

-----Original Message-----
From: Wilmoth, Deb [SMTP:Deb@...]
Sent: Tuesday, August 28, 2001 9:34 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Reconciling the A/P Clearing Account

<< File: ATT00028.htm >>
Thank you for your response.

I'm not sure I follow. Let me give it a go. After 9/1, when the A/P Aging
Report is run, you do not allow any more invoices to be backdated with an
August date. You change them all to 9/1 or just the invoices that are
processed on 9/1?

How does this help with the reconciliation of the A/P Clearing Account when
miscellaneous charges have the wrong period attached to them?

-----Original Message-----
From: Alex Neutgens [mailto:alex.neutgens@...]
Sent: Tuesday, August 28, 2001 10:26 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Reconciling the A/P Clearing Account


I can probably help you a little with the problem of invoiceing from the
prior month after you have printed your AP aging. This also applies to
many other reconciliation issues relating to backdating to the prior month.
You can make a report where the posted (actual) date is after the date you
run your aging. The aging plus this custom report should equal the GL
balance. Unfortunately there is not a posted time field to run a report
against. We don't allow backdating on the day we run our aging report.
For example. Run the aging on the first of the month. Make the custom
report list all transactions with a posted date greater than the first of
the month. It works fairly well for us and the auditors.

Alex Neutgens
Controller
Circuit Check, Inc.
763-694-4110



[Non-text portions of this message have been removed]
By using the actual posted date (a system field) in a report builder
report, you can run a report of a transactions posted after a date for a
period. For example, you would run a report for all transactions posted to
the AP account for the August period, but have a actual posted date (use
field GlJrnDtl.PostedDate) greater than 9/1. This will give you a report
of all invoices with a transaction in the August period, but posted in
September. Give me a call if you have questions.

Alex Neutgens
Controller
Circuit Check, Inc.
763-694-4110

-----Original Message-----
From: Wilmoth, Deb [SMTP:Deb@...]
Sent: Tuesday, August 28, 2001 10:37 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Reconciling the A/P Clearing Account

<< File: ATT00035.htm >>
Karen, I can see how this would work. However, then A/P is understated for
all the miscellaneous charges (freight, taxes, lot charges, cert fees, etc.)
attributable to those invoices in the previous month. IF those are not
large $ amounts, not much harm is done. It is rotten to have to make work
arounds and pick the lesser of the evils. I would prefer to see the
programming changed OR reports that accurately reflects the period so that
reconciling all balance sheet accounts is possible.

-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Monday, August 27, 2001 10:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Reconciling the A/P Clearing Account


Yes, I reconcile the A/P Clearing each month to the penny. The key to
getting the "Received but not Invoiced" report to match the GL is to run the
report on the 1st of the month before any AP activity has been recorded.
What happens is that if you do not run the report and clear an invoice in
the month you are actually in, that invoice disappears off the report, even
though it was still in clearing at the previous month's end. Once an invoice
is cleared, it is gone off the report, not matter what day you run the
receipt date to. To avoid confusion and backtracking to make the report
match, we run the report on the first and don't clear any invoices in the
previous month.

Karen Brodniak
Accounting Manager
karen.brodniak@...



[


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