1. Home
  2. QuickBooks Discussions
  3. Tracking by payor

Tracking by payor

I use QB Pro to track my company's finances, except that I do not use it for invoicing because our process management database is tied in to our invoicing process and it all works nicely well together. That app has an accounting function, but for several reasons I prefer to use QB. When fees come in, they are noted first in the process database and then recorded in QB. There's no problem tying them in to the appropriate account(s), and I also record the payor. The payors are on QB's customer list. The problem is that, without using the invoicing process in QB, I cannot view all the payments from a particular customer by going in to the customer list and looking at the linked transactions. To put it another way, although the deposit appears to link to the customer, it does not show up when viewed by customer. Is there some way to work around this so I can quickly look to see what has come in from any particular customer?

Reply to
Joseph N.
Loading thread data ...

Enter the receipt as a sales receipt.

Reply to
Haskel LaPort

Simplest way is to left click on the customer name & select Find from the pop-up menu - this will show all transactions using that name.

If you want multiples or a report format, do a quick report & modify it to show all transactions from customers & then save. What you need to change depends on what year QB you're using.

Scott out.

Reply to
Scott

It must be hard and waste of time to enter the payment data twice - once into your process management database and then again into QuickBooks either as invoice/receive payment or as sales receipt, especially if the volume is high.

You may want to use simple data extract tools to create invoice and receive payment or sales receipt data in QB. You can either use IIF or QBXML to export data into QB. Please visit

formatting link
tosee some of the projects we have done in this area. Will be glad toprovide programming help or guide you through the process. Pleascontact us at snipped-for-privacy@infonics.com

Reply to
InLattice

What happens when nothing shows up, which is exactly what will occur?

Reply to
Haskel LaPort

The purpose of the sales item is to specify the Income account you want to associate the payment with.

By default, the transaction will Debit Undepositd funds & Credit {account on sales item}.

To change the use of the Undeposited funds go to Edit>>Preferences>>Sales& Customers. On the Company preferences tab unchecked the "use undeposited funds" option on the bottom of the page. This will now give you the drop down menu on the sales receipt and Receive payments screens so that you can select any bank account you want.

The only thing that you are changing is account the money is deposited into. You still need to use the Sales Item to specify what income account your sales are posted to.

Reply to
Laura

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.