journal entries using excel/ diverse boekingen via Excel

Journal entries using Excel

Till a few years ago, the monthly and yearly closing activities were very labor-intensive and time-consuming in the accounting department, because they regularly had to execute  a lot of returning journal entries. Some of them needed correction in the following month.

The monthly postings of salaries and wages also were  an extremely time consuming activity.

But the accountants were inventive, made copies of their (handwritten) posting pieces, but still these copies needed to be manually posted into the system.

The software houses created templates, where data could be fixed, to avoid manual interventions.  But still it remained labor-intensive, because it regularly happened  that the posting lines stayed the same, but the amounts didn’t.

An elegant and interesting solution is the possibility to post these journal entries using excel templates into the system.

RACS was one of the first to offer the possibility to post these journal entries using excel, and meanwhile continued to develop this feature until it became a very useful tool for the RACS users.

What is the advantage? Excel is easy to manipulate, therefore the content of these files can be easily changed.  Change an amount? Change an account or cost center?  Add or delete posting lines?  No problem.

RACS offers the possibility to post Excel prepared posting lines very easily.  So you can use extremely long documents repeatedly, with or without small changes.  And it is easy to create returning postings, simply by changing the sign of the amounts.

RACS even offers the possibility to use the Excel files for posting incoming and outgoing invoices.

Imagine: You have a number of  invoices of different power suppliers that need to be divided v over a large number of cost centers and projects. An invoice of one line results in dozens of posting lines.

Do you like to perform these manual interactions on a monthly base?

RACS gives you the possibility to create an Excel file and with the help of some formulas, you can split the invoice  into a detailed posting sheet.

The accountant’s life becomes less boring, because he does no longer have to post all these lines manually. A simple copy/paste from excel, and all is properly posted by RACS, included an automatic numbering in the desired books

I guess you too have more interesting things to do?