Is this the correct way to prepare a debit note or incorrect guys let me know. Or if someone could prepare it for me and post it over here please.
To, DEBIT NOTE # 2012- 31 /12 /13
IEC No: xxxxx
xxxxx PAN No: AxxxxxxK
Date: 23rd May, 2012
Description AMOUNT IN USD AMOUNT IN USD 30% amt received against xxxxx as on 9th May 2012 2371.20 xxx Purchase xxxxxx 925.00 Sampling Invoice # 19 as on 10th May 2012 165.00 Sampling Invoice # xxx as on 20th Jan, 2012 475.54 Sampling Invoice # xxx as on 20th Jan, 2012 726.60 Sampling Invoice # xxx as on 17th Feb, 2012 1744.20 Total 4036.34 Now if we minus $4036.34 with 30% advance amt $2371.20 so Total left would be $1665.14 which is mentioned. Therefore the total amount balance due on xxxx xxxx on the xxx Account is $1665.14. One Thousand Six Hundred Sixty Five & Fourteen Only. -1665.14
(This is a computer generated invoice and does not require a signature)
Uh... the correct/incorrect way kind of depends on your company and what they want. Or your bank or customer... I'm really not sure what you're actually asking here.
Ken Puls, CMA, MS MVP (Excel)
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.