SageForum for UK versions of Sage 50- Help and support.

Hi All,

I have been given a set of transactions in excel that were generated from Sage. I am trying to do some analysis on a company's historic overall cash flow - and therefore need to be able to categorise transactions into physical money in and out. For example it seems fairly obvious that JD/JC (Journal Credit/Debit) entries can be ignored as they seem only to relate to internal movements of money - however others are not so clear, for example I'm not sure what PC (Purchase Credit) is referring to. I am therefore wondering if someone can categorise the transaction types into Money In, Money Out, Not Needed...

Below are all the transaction types I have been given.

BP (Bank Payment)
CP (Cash Payment)
PC (Purchase Credit)
PA (Purchase Account)
PP (Purchase Payment)
SI (Sales Invoice)
PD (Purchase Discount)
VP (Visa Payment)
JC (Journal Credit)
BR (Bank Receipt)
CR (Customer Receipt)
SA (Sales Account)
SR (Sales Receipt)
SC (Sales Credit)
PI (Purchase Invoice)
SD (Sales Discount)
VR (Visa Receipt)
JD (Journal Dedit)

Thanks,

Paul.

Well things like journals could be something to do with cash flow or not. The PC PI PD SI SC SD transactions have nothing to do with cash flow.

All the rest are transactions that involve the bank accounts so are cash flow.

Typically we would look at the outstanding invoices on the ledgers for predicting cash flow but as you are doing a historical analysis this would not be relevant.

Brilliant - thank you. Someone else on another forum corrected my assumption about Journal entries - however in the accounts I am looking at I believe they only use Journals to allocate money that has been paid out as deposits to the time period for which the deposit is relevant, so it is not relevant for my analysis of historic cash flow.