View original (French)

Create accounting tables in Word

nonossov Posted messages 638 Status Member -  
contrariness Posted messages 17903 Registration date   Status Member Last intervention   -
Hello my friends,
Thank you for helping me figure out how I can create ledgers in Excel like the accounting journals, if you know them? I will put an image of these ledgers below, thank you my friends.

https://www.cjoint.com/c/GBpjUF8O5hD

2 answers

  1.
    contrariness Posted messages 17903 Registration date   Status Member Last intervention   6 243
     
    "Concrete" doesn't ring a bell for me either... I know the "T" accounts, but it doesn't look like the example...

    In Word, the best way is to create a table with 5 columns and x rows.
    Then, enable the cell borders where you want to have the horizontal and vertical lines...

    Once you've created one, you can copy/paste it to fill it in with the new data...
    1
    1. nonossov Posted messages 638 Status Member
       
      Just a question: how can I get the structure in the attached PDF file?
      0
    2. contrariness Posted messages 17903 Registration date   Status Member Last intervention   6 243
       
      There are 5 columns:
      2 for account numbers
      1 for the description
      2 for debit and credit

      The number of rows is the same...
      A debit or credit entry represents 1 row, meaning 1 cell row in the table
      The number of lines in the cell (for the description) does not matter, you can have several, but since it's for the same entry line, we place them in the same cell row..
      You simply use tabulation to distinguish the description for the debit and that for the credit (as in your example)

      You can also put 1 entry per cell row if you find it simpler.
      0
    3. nonossov Posted messages 638 Status Member
       
      Bien compris Mr, comment puis-je ajouter de l'espace dans le libellé ? Et entre chaque écriture débit et crédit ?
      0
    4. contrariness Posted messages 17903 Registration date   Status Member Last intervention   6 243
       
      It's a presentation, you can adjust the margins inside the cells.

      Right-click in the table / Table Properties / Table / Options.. change the top & bottom margins or set a value for the spacing between cells.
      0