Skip to main content

Entries

Explore transactions, with the option to configure adjustment entries and intercompany eliminations.

Updated over a week ago

Transactions

The Entries page provides a complete overview of all transactions, allowing you to review, filter, and manage financial data efficiently.

  • Use the calendar and filter options at the top to refine results.

  • Quickly locate specific transactions using the Search bar.

  • Selecting a transaction opens a side panel on the right, where you can review details and start discussions—similar to the entry panel in Reporting.

Identifying Specific Transaction Types

  • Intercompany Eliminations are labeled with the prefix [IC] in the Entity filter.

  • Adjustment Entries use the prefix [Adj], allowing you to track and modify corrections easily.

Adjustment entries

Use Adjustment entries to correct or supplement transaction data. Manage adjustments and intercompany eliminations directly from this page, either manually or with bulk updates for greater efficiency.

Step-by-Step Guide: Adjusting Entries

1. Choose an Adjustment Method: Manual or Bulk-Upload

  • Navigate to Finance → Entries in the left-hand menu to view all transactions.

  • Click Add in the top-right corner and choose:

    • Adjustment to manually create a single entry.

    • Upload file to bulk-upload multiple entries at once.

2. Creating a Manual Adjustment Entry

  1. Click Add Adjustment.

  2. Select the Entity and set the Entry Date using the calendar.

  3. Enter transaction details row by row, including:

    • Accounts

    • Transaction Description

    • Relation (optional)

    • Debit and Credit values

  4. Ensure that Debit = Credit before saving.
    ​


    ​

3. Bulk-Upload Adjustment Entry (Upload file)

  1. Click Upload file

  2. Download the Excel Template by clicking the icon under "Need a template?"

    Tip: Always use the Finstack-provided template to avoid formatting errors.
    ​

  3. Fill in Your Adjustments

    Open the downloaded template and complete:

  • Entity selection (dropdown in cell B5).

  • Account Number and Transaction Description.

  • Debit and Credit amounts (ensure they balance).

  • Verify the Check column reads 0.00, confirming balanced entries (cell K4).

  1. Save and Upload

    • Save your completed Excel file.

    • Return to Finstack, click Upload Excel file, and select your saved file.
      ​

  2. Review and Save

  • Once uploaded, click Save to confirm.

  • Your adjustments will appear in Finance Entries, prefixed with [Adj].

4. Filter & Review Your Adjustments

Adjustment entries are stored under a virtual entity with the prefix [Adj]. To view them:

  1. Filter for Adjustments

  • Use the Entities dropdown in the Filter menu to select entities prefixed with [Adj].
    ​

  • Click Apply to display only adjustment entries.

  1. Edit Adjustments

  • Locate adjustments in the Transactions table.

  • Select a row to open the side panel on the right.

  • Make changes directly and click Save to store them.

  • To remove an entry, click Delete.

  1. Check Adjustments in Reporting (Optional)

  • In Reporting, click Filter to:

    • Toggle adjustments on or off.

    • Select specific entities to review.
      ​

That’s it! 🎉

You’re now ready to upload adjustment entries manually or in bulk. If you have any further questions or run into any issues, please reach out to our support team.

Best Practices and Tips

  • Balance is key: Make sure your debits and credits sum to zero for each adjustment. The template’s Check column helps verify this.

  • Use the correct entity dropdown: Double-check that you’re selecting the right entity in cell B5 before entering any amounts.

  • Clear, descriptive transaction info: A good Transaction Description (e.g., “Adjustment for January Utilities”) makes it easier to track and understand your financials later on.

  • One entry date per row: Keep dates consistent for entries that belong to the same period.

  • Filter by [Adj] : To quickly locate all your adjustments, filter on entities that begin with [Adj].

FAQs

1. Can I reuse my own custom Excel format?

No. Always start with the Finstack-provided template. Renaming columns or changing the layout may cause upload errors.

2. What if I need to edit an adjustment after uploading?

Locate the adjustment in Finance Entries and edit it manually, or delete and re-upload the row if a complete replacement is needed.

3. How can I confirm that the upload worked?

After saving, the newly created adjustments appear in the Entries overview. Use the filter to view entries labeled [Adj].

4. Can I upload adjustments for multiple entities in one Excel file?

Yes, you can. Just be sure you select the correct entity from the dropdown in each row.

5. Do I need special permissions to import adjustments?

Yes, depending on your role. If you don’t see the “Upload file” option, contact your administrator.

Did this answer your question?