Can I apply journal entries to bills through csv i...
# ask-stanley-ai
r
Can I apply journal entries to bills through csv import?
c
AI generated answer (using internal Slack threads):
Based on the conversations provided, it is possible to apply journal entries to bills through CSV import. However, it's important to note that while you can add new lines and overwrite all lines, you can also update it referring to a unique line id. This has been done several times by the users in the conversation. However, you should be aware that you may unapply payments if these entries have participated in such a process. For the case of importing open accounts (bills) and also getting TB data in (journal entries) without overlap or double postings, the following steps were suggested: 1. Post GL journals month by month to support trial balances in home currency of the subsidiary. 2. Then journal the full balance to a P&L account (I use one called open AP suspense) in the closing period. 3. Raise your opening bills with original dates and exchange rates (but all hitting the closing period), with a single item or expense coded to the open AP suspense account and an outside scope tax code. 4. Run Revaluation. Your open AP should be equal to what your journals were. 5. Move any residual balance from the open AP suspense to unrealised gain/loss (this is where the other side goes). 6. Now when you pay your bills you will get the right realised gain/loss impact, and if someone tries to credit an opening balance transaction directly, it will go to the P&L so can more easily be monitored than if it goes to an equity or balance sheet suspense account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.861946821
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.855184138
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.850554049
Please provide your feedback on this answer.