I’m importing csv cash sale transactions. The service dates for these transactions are for different service date ,however ,the deposit in one day. I need to map in a way to capture the service date (for Revenue Recognition) and deposit date remains in one day ie the date of cash deposited. Is there anyway to do that? Tks

I’m confused with the terminology here. Cash sales always have the revenue date as at the same date as the payment. A Make Deposit transaction puts it to the bank. Maybe you need to be importing as Invoice/Customer Payment to get your different dates.

What you are saying is true. The cash sale recognizes revenue and get deposited to the bank the same date or day. This is in normal situation where you are selling an item for cash over the counter , however, in my situation I’m importing insurance transactions that are billed and paid by another software as cash sales in order to consolidate revenue streams in NS. The only issue I’m forced to date all these transactions as per cash sale date and not the service date which makes it easier to deposit all these transactions at one date hence matching at the same time the money deposited and paid by insurance against these transactions. In the import fields for the cash sale there is “document date” and “cash sales date” , however, the document date is the one determining the cash sales date.

It would be two imports but you could use the same flat file, different columns for the import. I would use an Exernal Id to keep them linked

Thanks . It will be a lot to do and already time consuming. I have thousands of transactions to import monthly. I appreciate your response

For that you could be looking at a more automated solution.

you could always cash sale into a clearing account and transfer to a proper account the following day. Your auditors might want you to categorise the clearing account as trade debtors though

Tks Jon. Actually I’m depositing into cash account and doing adjustment with receivables for 3 rd party that usually receives the cash in their bank

maybe you will need to post the transactions to deferred revenue account then post an accompanying JE on the date you want to see the revenue.

Tks