Hello all:
I am hoping someone who has already experienced this issue can offer me some strategy advice based on real-world knowledge! First allow me to say that I have read (today!) all of the postings to all the different topics, in order to glean as much info as I could about possible solutions.
We accept several forms of Merchant payments (Visa, M/C, American Express, PayPal). All of these Payment Types are currently set to post to the Undeposited Funds Account, so that we may use the "Deposits" function to post batch deposits to the Checking Account. Since there are so many transactions posting to the Undeposited Funds account, I have run into the issue where it is difficult to reconcile, so I thought I would go with the idea of posting each Payment Type by day. Then at least I would theorectically be able to reconcile to the Merchant Deposit statements we receive monthly (like from Visa).
However, at the point I am to do the monthly reconciliation, I will need to record the Merchant Fees as well. For example, with PayPal, the Sale is recorded at $100, and the customer payment in NetSuite is recorded as $100, but in reality the cash deposited from the Merchant would be minus the fees -- so we receive less than the $100 (just say we get $75.00). So, the fees are not recorded, and the Sales "Profit" is overstated because of this.
I guess I am looking for some ideas on what is the best way to approach these reconciliation issues. A "per-transaction" reconciliation would never be possible due to the sheer volume of transactions. And yes, I can implement the daily deposit of Merchant Sales and that will help some.... but technically a Sale that is posted in NetSuite on the 30th might not hit our Merchant Account for deposit until, say the 2nd. So there is a date lapse that would interfere with reconciliation. But I am most interested in how other Users track these hundreds of Merchant Payments? There is such a large volume of transactions to keep track of! I am planning on doing a monthly General Ledger entry to record the Merchant fees info from their statement, but the thought of going thru the hundreds of transactions is so overwhelming! I have contemplated setting up "Bank Accounts" for each Payment Type, but then I would not be able to utilize the "Deposits" feature to record the funds being posted to our Checking Account. Have anyof you done this?
Does anyone have any real-world solutions that would be beneficial to us? How do you manage these multitude of transactions, and all the fees? Any advice you can offer would be greatly appreciated! I would like to be able to set things up (going forward from here) to run in the most efficient method, and be able to accurately report what we are paying on fees, etc. Then I can go back and fix all the older stuff that is in wrong.
Thank you very much!! Kimberly - Discount Ramps.com