Peachtree and Sage 50 Forums      

Go Back   Peachtree and Sage 50 Forums > Peachtree and Sage 50 software > Peachtree / Sage 50 Accounting forum

Thread Tools Display Modes
Old 06-30-2007, 04:19 PM
KPE2007 KPE2007 is offline
Registered User
Join Date: Jun 2007
Posts: 2
New Company's closing entries causing trouble

We purchased a machine shop and moved a manual accounting system to Peachtree successfully. During the closing, we bought a portion of the AR, which is a standard negotiation. Upon arriving at the dollar amount, we made a "total" debit entry for all of the AR line items we bought to accurately reflect the closing assets for the bank, et al. All good for now, back then...

But now, the problem is we created the actual sale journal entries for the actual line items as the checks were received. (We created back dated debits and actual date credit as the line items' payments were received). We had to back into this, as the previous owners had a tenuous control on these transactions.

The Good; All is OK from a total sales and AR perspective in the monthly reports.

The Bad: But the Balance Sheet shows this debit in the Total AR calculation in Assets.

What we tried: The double entry system keeps us from removing this "total" place holder transaction. It shows up in the GEN Journal when viewing the AR General Ledger. We've tried a credit memo in the Sales Journal, but is messes up Year Total Sales. We've tried zeroing out the redundant debits that add up to the "total" entry, and it messes up the total sales.

So we're stuck and hope someone has a suggetion. Basically, if we knew better, we wouldn't have made this entry and would have made the individual entries. I've manually reconciled the debits and credits from the GL AR account in MSExcel and it matches the monthly revenue and AR values from the canned reports.

We need a method to eliminate or move this transaction in a way we can zero it's affect on our reporting of assets.


Reply With Quote
Old 07-01-2007, 03:51 PM
LauraG LauraG is offline
Registered User
Join Date: Nov 2003
Location: West Yarmouth, MA
Posts: 2,235
You need to go back into the opening financial period and correct that original entry...

Do you have the details of the "total A/R" you purchased figured out? Your opening trial balance should include this A/R purchased. You need to go into the Maintain customer screen and click on the Beginning Balance button. Here you can enter the details of the A/R balances by customer. This will allow you to clear each opening balance as they were paid.
Reply With Quote
Old 07-02-2007, 08:40 AM
KPE2007 KPE2007 is offline
Registered User
Join Date: Jun 2007
Posts: 2

Hi Laura:

Thanks for the help. We have the details and will look at this option. I've not tried this yet.

There's a single entry for the closing debit of $72K, and then the redundant debits for each line item, as the payments (credits) were received.

Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

All times are GMT -7. The time now is 07:20 AM.

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
all contents copyright (c) by AccountingUsers Inc.