Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I need to pay invoices without affecting my bank balance

Status
Not open for further replies.

whuppie

Technical User
Aug 21, 2007
6
I am new to Peachtree, and am setting up our new company from the first of the year. I have entered my customer invoices, but now they show open when they have really been paid. How can I have these invoices show as Paid, without affecting my bank balances (I have already balanced my bank statements for Jan - July)?
 
I need to pay invoices without affecting my bank balance

If you figure out how to do this, please post it! I am VERY interested.

To be serious for a moment, I am sure there is a way to do this, hopefully a Peachtree expert will be along shortly.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"If the phone doesn't ring, it's me".....Jimmy Buffet
 
One of the eliments in the pay screen is the checking account. Set up a cash account for this and use that as the bank account. Then you can balance that out against owners equity. Right now I'm assuming your liabilities are over stated so you should be able to get in balance. Probably a lot of tricking accounting, however.

It is also possible that in your case you want to use credit memp's to close the invoices. Depends on how you set things up. I.E. did you bring in the money? and the bills.

If this works keep in mind that Peachtree remembers the last "checking account" used. You'll want to be carefule to get it back to the right one. when you are done.

Remeber to document in case you get audited. What your income statement.

Bill Couture
 
Additionally, if you are just setting up a new system you should only have entered the OUTSTANDING (not paid) invoices. You could have entered a customer history that would not have affected your AR.

Bill has a good idea of setting up an account that you can use to "wash out" all the invoices that have been paid but not marked paid.

I'm wondering how you balanced your bank account? Did you just enter the deposits against your sales account? If so, then your sales are definitely overstated because when you billed the customer a credit was posted to sales and a debit to A/R. When you posted the deposit that posted a credit to sales and a debit to the bank. You've now credited your sales account twice for the same sale/income.

HTH

Leslie

Essential for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins
 
Good point maybe should wash out againt AR instead of owners equity. Peachtree is a great package but you still have to know accounting to use it. Quickbooks pertends you don't which is why it seems like half the Quickbooks set ups I see are goofed up.

Bill Couture
 
That's one of the reasons that I like Peachtree over Quickbooks, it's more of an accountant's package.

Like you, almost every QB setup I've seen is wrong. And the liabilities , especially PAYROLL taxes, are NEVER correct! And QB doesn't make it easy to correct those kinds of issues.
 
OK, so after reading all of your tips (thanks very much), I decided to delete the invoices. (I didn't enter those invoices until after I had balanced my checking accounts.) So, now I need to somehow enter those sales numbers so my sales for the year are correct. Any suggestions?
 
I used Sales Income - really the only account I have set up for incoming cash
 
that's where you should be recording the sale, not the cash...you record the cash into the bank account. Have you solved your issue yet?

Leslie

In an open world there's no need for windows and gates
 
I think so... I have deleted the invoices and entered the sales as a journal entry.
 
So now I have a new question...

When we receive an order for our product, I generate an invoice and at the bottom of the invoice, there is an arrow that allows you to record payment made toward invoice. I have been doing that, making sure I put that into the correct bank account, but then when I download my bank information, if I made a deposit with more than one check, I cannot manually match them to what Peachtree has put in my account. There has to be a way to do this?
 
I'm guessing you mean when you are reconciling the bank account?

Leslie
 
yes, when reconciling my bank statement...
 
Peachtree takes all the "deposits" for a single day and lumps them together in the reconciling view. So, if you have applied payments to 4 invoices on the same day and they total 255.35, peachtree expects that you have taken all the money to the bank on that day and you will have a deposit at the bank for $255.35

So you just need to make sure that you have the correct date on the receipt for the deposit so that peachtree can calculate your deposits correctly. I think that if you make the payment in the invoice that the invoice date will be the deposit date (I'm not positive about that and I don't have a peachtree installation to check right now).

HTH
Leslie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top