Showing posts with label Practical Examples. Show all posts
Showing posts with label Practical Examples. Show all posts

Thursday, September 6, 2012

Convert to Debit/(Credit) Amount by using Paste Special

Excel is one of the important tool for finance professionals. If I want to present anything or want to draft anything, my mouse directly hit Excel.

Today topic may be very much useful for the accounting guys, who post Journal Entries in the systems.

Most of the ERPs (Enterprise Resource Planning) allow the Journal Entry in the following way.


ParticularsDr/(Cr) Amount
Cash a/c$2,500.00
Income a/c$(2,500.00)