debtors

Hello, I am very new to Excel VBA, i have worked on a few codes based on the forums available on MR Excel. I currently require a vba code for Debtors Management. I have 12 worksheets in a workbook each one for a separate month, in which i have a column called category in which i enter Debtors to...

Hi, I am trying to set up ledgers for my business and I would like to pull amounts to the respective sheet if I use particular words. For eg. if I record CASH on the SALES LEDGER it pulls the data to the CASH LEDGER and if I record DEBTORS on the SALES LEDGER it pulls to the DEBTORS LEDGER...

Hi, Im trying to add in some way of tracking debt of customers in a spreadsheet. So far the formula say if a date is over 60 days then it will say Recourse =IFERROR(IF(O2>60,"RECOURSE"),0) But i now need it to do the same thing track if an invoice is over 60 days but also if the customers...

hi, Just need a bit of help with some data for over due invoices. for example the data will look like <colgroup><col><col span="3"><col span="4"><col><col span="2"></colgroup><tbody> Date Balance Current P1 P2 P3 P4 Older Due Date Payment Terms Days Overdue 19/09/2017 2,160.00...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would like to write a vba code so that to “run” through col. “A” and where the left 2 numbers are “85” should delete the whole row. In 1st schedule is an extract of...

Hello. I'm having some trouble with this formula. Can someone please help? example: cell B5 says -6% formula ="aged debtors decreased by "&B5 ideally i would like the result to be "aged debtors decreased by -6%" but is coming up with "aged debtors decreased by -0.56988713816163" any help...

anyone here can make any suggestions to the following situation: i have to worksheets in a workbook one is receivables ledger and other is debtors aging now the problem here is i need a format by which i make receivables ledger entries and it records itself automatically in debtors aging and...

Hi All, I am currently in the process to developing a financial dashboard. I have debtors column chart by month. I also want to show the ageing balance on the same chart. For example the line for November would be split into three colors based on percentage of 30days/60days & 90 days. Is this...

Hi there. I have a long list of invoices and cash payments which I need to find the offseting entries. There are over 1,000 accounts and each account can have many entries, so over 20,000 lines of data, a long and laborious task which I have to do every week! The lady before me did this...