millennium.atrex
Reconciling
Thread Starter: Stan Started: 8/20/2010 6:43 PM UTC
Replies: 3
Reconciling

Hello,

I currently run Atrex version 12.

Every day I print out a revenue report and check it against my credicard batch, cash in the drawer and checks received.  Service orders work perfectly since they show up on the report when they are closed out.  We only close them out when the customer pays.

Invoices are a little more difficult.  Say we make an invoice today.  It will show up on the revenue report today.  At this point it is not paid for.  Three days later the customer comes to pick it up and pay for it.  If I print out the revenue report now it does not show up on the report.  So in this case I have either extra cash, extra money on the credit card or an extra check.  Is there a report or a query I can run that will tell me what invoices were paid?

Hope that makes sense.

 

Thanks,

Stan

Re: Reconciling
Stan,

Invoices are a little more difficult.  Say we make an invoice today.  It will show up on the revenue report today.  At this point it is not paid for ..  Three days later the customer comes to pick it up and pay for it. If I print out the revenue report now it does not show up on the report. So in this case I have either extra cash, extra money on the credit card or an extra check.  Is there a report or a query I can run that will tell me what invoices were paid?

This is actually working exactly as it is designed.  If you create an invoice on the 1st, the revenue report reflects the revenue from the transaction date.  So if you go back and edit an invoice on the 3rd, you are editing the revenue for that transaction which is the 1st.

There are two things that can help you.  The first is to use the "Accounts - Cash Drawer" functions.  The combined cash drawer report will show you all of the money that went in or out of the drawers on the day that it was changed.  So even if you edit a transaction from a day prior, it will show up on the drawer reports on the day that it was modified.

The other is to use the Sales - Order function.  This allows you to set up what the customer is going to purchase on one day, and then ship (transfer) that order to an invoice when they actually pick it up.  This is the proper way of doing what you want and would allow your sales reports to match the revenue reports as well.

--  

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

Now shipping Atrex 13.  For more information go to
 http://www.atrex.com/news.asp

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------
Re: Reconciling
On 8/20/2010 2:30 PM, Terry Swiers wrote:
Stan,

> Invoices are a little more difficult.  Say we make an invoice today.  It
> will show up on the revenue report today.  At this point it is not paid
> for ..  Three days later the customer comes to pick it up and pay for it.
> If I print out the revenue report now it does not show up on the report.
> So in this case I have either extra cash, extra money on the credit card
> or an extra check.  Is there a report or a query I can run that will tell
> me what invoices were paid?

This is actually working exactly as it is designed.  If you create an
invoice on the 1st, the revenue report reflects the revenue from the
transaction date.  So if you go back and edit an invoice on the 3rd, you are
editing the revenue for that transaction which is the 1st.

There are two things that can help you.  The first is to use the "Accounts -
Cash Drawer" functions.  The combined cash drawer report will show you all
of the money that went in or out of the drawers on the day that it was
changed.  So even if you edit a transaction from a day prior, it will show
up on the drawer reports on the day that it was modified.

The other is to use the Sales - Order function.  This allows you to set up
what the customer is going to purchase on one day, and then ship (transfer)
that order to an invoice when they actually pick it up.  This is the proper
way of doing what you want and would allow your sales reports to match the
revenue reports as well.


Second to what Terry says, although I have found quotes work better than orders, as a tranfer of a quote will end up in an invoicing screen that can had additions / changes, etc.....shipping an order goes straight to printer. For any deposits, we make an invoice for "deposit" sku (non taxable) +1 unit, deposit $$ as price......then you can use +1 unit and -$$ on the final invoice to deduct the deposit....and this can be added ahead of time to the quote (Note that using a negative quantity on the quote does NOT trasfer properly)

But, Terry's way is the way Atrex was designed.....just is lacking for add-on sales at time of pick up.

Greg, Plasticworks.
Re: Reconciling



Both posts are extremly helpful.  Thank you very much for your time!

Stan