Pastel Accounting reports & Cost Accounting development through Excel VBA programming

24 days ago33 views
Ad Saved to My List
View and manage your saved ads in your account.
Report Ad
General Details
Description
I am a gentleman with both my National Diploma in Cost Accounting and my IAC Diploma in Accountancy, of which through my 30 years work experience, I did debtors, creditors, cash book, reconciliations, general ledger and Fixed Assets register in order to do the books up to Trial Balance on Pastel Partner, Pastel Xpress and Sage One. This involved me mastering úsing MS Excel VBA programming by creating macros to record specific tasks and then being performed by using menu buttons, which will include opening workbooks and going to spreadsheets automatically, letting different reports be created; such as the Income Statement to be updated from Pastel into Excel format, to let the Net Profit or VAT owing to SARS, to be calculated per month on a different spreadsheet, and then by the use of formulas one spreadsheet will add the total for the financial year; as well the Fixed Assets register, where different spreadsheets for different fixed assets will be calculated to work out the Depreciation, and then the formulas to calculate the Accumulated Depreciation for the difference types of Fixers Assets, as well as other monthly reports such as wages and salaries. I started mastering using Excel VBA programming when having to create a costing system on Excel for an engineering company, and then a food manufacturing business, of which I had one spreadsheet with the cost prices of the goods used for production by the various suppliers, as well as the different labour rates and overhead rates per department, of which will be linked to various spreadsheets or workbooks which calculates the cost of manufacturing a specific items; or doing specific jobs; to let the cost prices of the products or jobs to be performed, to be done in a quicker and easier way If anybody is interested in my work experience, you can phone or WhatsApp me, Ronald Joshua, on 0764685419, or email me on rjoshua124@gmail.com for a copy of my CV.
Id Subtitle 1272144793
View More
Ronald Joshua
Selling for 8+ years
Total Ads32
Active Ads7
Seller stats
32Total Ads
1.77KTotal Views
Verified information
Mobile number
Email address
Contact Ronald Joshua
076*******Show Number
Message
(3961)
Phone
(Optional)
Include my number in my message.
Send Message
By clicking "Send" you accept the Terms of Use and Privacy Notice and agree to receive newsletters and promo offers from us.