# New Audit Trail (aka History)

**URL:** <https://forum.manager.io/t/new-audit-trail-aka-history/28801>\
**Category:** Uncategorized\
**Created:** [June 16, 2020, 10:34am UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801 "2020-06-16T10:34:23Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 16, 2020, 10:34am UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/1 "2020-06-16T10:34:23Z")

</div>

The latest version (20.7.14) is adding new audit trail across all editions. It’s a big improvement over the old one.

- You can click `View` on any entry to see exactly what each user has created, updated or deleted.
- Captures all changes to database including batch operations, bank statement imports, auto-categorization using bank rules, added/removed attachments, find & recode operations, cash/bank account conversions, bulk-creation of pending recurring transactions etc.
- Ability to undo anything if necessary (e.g. you accidently bulk delete some transanctions, you can simply undo it).
- Unlimited number of entries (previous audit trail has shown only last 500 entries).

New audit trail is per business and can be accessed using `History` button in the top-right corner:

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/3/63039731c6d78322c10ee53690d577ef656243b7.png)

The implementation is not yet as pretty as I would like but I would like to start collecting feedback on this to make sure I’m moving the right direction.

---

<div class="post-metadata">

**Author:** ![waiminn](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/waiminn/32/17090_2.png) [@waiminn](https://forum.manager.io/u/waiminn)\
**Post date:** [June 16, 2020, 11:59am UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/2 "2020-06-16T11:59:56Z")

</div>

Audit trail per business is a long waiting, most wanted feature for us and addition of ability to undo anything is awsome feature also. Currently my suggesting is that the first creation of entry no need to show undo button, and value diff on history should show a cleaner view i.e old value and new value with two column. Whatever a really great improvement and we love it. We will test through this feature and will do feedback again. Thank you @lubos.

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [June 16, 2020, 12:28pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/3 "2020-06-16T12:28:31Z")

</div>

Looks very interesting and I think it is a capability I may use.  
Looking at what it is doing, it is going to collect a lot of data fairly rapidly.  
I suspect the issue in the longer term will be meaningful access of the data.

- Searching within the history screen eg by user or modification type will help

- Another way would be to have context specific history ie the history shown is filtered depending on what screen the user is looking at when they request history. For example the Summary screen would show all history, the journal entry tab showing less, a journal entry showing very specific information.

I don’t really know what is sensibly achievable, look forward to seeing what it evolves into.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [June 16, 2020, 12:30pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/4 "2020-06-16T12:30:26Z")

</div>

Good start - however the undo is not without problems.

For example, can I create a customer, enter invoices and then in the History undo the Customer Create - the invoices are now posted to a suspense account but maybe it should not allow the Undo

Also,when I Undid the Customer Create - it not only deleted the customer, but the Create Customer entry was deleted as well - I think it should have been kept along with a record of the Undo/Delete

---

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [June 16, 2020, 1:11pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/5 "2020-06-16T13:11:23Z")

</div>

I think that undo in accounting should be used only as an extrema ratio and only after a backup like in batch update.

I still have to update our server edition but I hope that only the administration and authorized people could use it.

---

<div class="post-metadata">

**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\
**Post date:** [June 16, 2020, 1:36pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/6 "2020-06-16T13:36:21Z")

</div>

@lubos

1. if you delete an attachment from the **transaction** and then undo the deletion, the attachment can no longer be opened even though the attachment shows at the bottom of the transaction. i understand this is because the attachment is deleted from the business file. maybe these deleted attachments can be saved in a separate database in the app data folder in case the user needs to restore it.

2. suggestion to have an option to flush or batch delete the audit trail for administrators (sole users in the case of desktop edition). i have noticed that the audit trail feature adds to the size of the business file.  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/c/8c7e7aa9bf0fa584114b57b1936980a9181793d4.png)  
notice the size of the backup file i created before updating. the live business file was tested by adding an attachment ~1MB and then deleting it (the db was compacted after deleting the attachment).

3. in my opinion the `History` button could list only the audit trail corresponding to the tab the user is presently in. a complete audit trail can be listed only if the user accesses `History` form the `Summary` page.

4. the audit trail could show the type of transaction and also its reference as two columns so that users can search specifically whether a transaction was modified.

---

<div class="post-metadata">

**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\
**Post date:** [June 16, 2020, 3:25pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/7 "2020-06-16T15:25:25Z")

</div>

Good job @lubos, we have been waiting for this feature. This is great news!  
Thank you very much

**Suggestions**

1. I like the suggestions people are making above, but in my opinion, I don’t wish for the feature to show history according to the tab the user is currently in. I would want to see every history regardless of which tab I am in.
2. If a general ledger account is created or changes are made to a general ledger account, it would be nice to have the account code also showing in the history record (I know it shows when you click on view).
3. If possible, as requested above, if the entry is an update of a transaction, show the amounts (before and after in separate columns)
4. It would be nice to have transaction references appear as hyperlinks to enable the user to click and view the transaction document right from the historical record.
5. This 5th point is not necessary but can the history include login and logout (Opening and closing of the app) times of users?

---

<div class="post-metadata">

**Author:** ![ibdek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ibdek/32/21477_2.png) [@ibdek](https://forum.manager.io/u/ibdek)\
**Post date:** [June 16, 2020, 3:42pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/8 "2020-06-16T15:42:15Z")

</div>

These are long awaiting features we are expecting. Thank you for this.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [June 16, 2020, 7:55pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/9 "2020-06-16T19:55:58Z")

</div>

> [@Patch](#):
>
> Searching within the history screen eg by user or modification type will help

That capability is already there. You can Search and sort by column headings, just like on other Manager lists.

> [@Davide](#):
>
> I think that undo in accounting should be used only as an extrema ratio

I agree. After experimenting just a little bit so far, I am troubled by how easy it is to wipe out records. The only thing it is not easy to undo is undoing creation of subsidiary ledgers, like customers. @Joe91 commented about this. Undo creation of a subsidiary ledger and you not only un-create it, you destroy the record that it was ever created.

> [@sharpdrivetek](#):
>
> f you delete an attachment from the **transaction** and then undo the deletion, the attachment can no longer be opened even though the attachment shows at the bottom of the transaction.

Yes, so what is the point of being able to undo a deletion of an attachment? Better that undoing deletion of attachments not be permitted. And I do not agree with @sharpdrivetek’s idea about saving deleted attachments somewhere else. Suppose I’ve saved an attachment for a statutorily required 7 years and want to be rid of it. I would not want the program saving it somewhere at that point. Or suppose you attach the wrong file by mistake? You would not want it saved after you’ve corrected your mistake.

> [@Abeiku](#):
>
> I don’t wish for the feature to show history according to the tab the user is currently in. I would want to see every history regardless of which tab I am in.

This raises permissions issues. Do you want someone whom you have denied permission for bank accounts to be able to go back and see which ones have been created, changed, or transacted in? I think not. To my thinking, you have make access to History match permissions set elsewhere.

---

<div class="post-metadata">

**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\
**Post date:** [June 16, 2020, 8:01pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/10 "2020-06-16T20:01:39Z")

</div>

> [@Tut](#):
>
> This raises permissions issues. Do you want someone whom you have denied permission for bank accounts to be able to go back and see which ones have been created, changed, or transacted in? I think not. To my thinking, you have make access to History match permissions set elsewhere.

Limited Users are not supposed to see history or the Audit Trail. Audit trail is for administrators and Auditors.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [June 16, 2020, 8:24pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/11 "2020-06-16T20:24:18Z")

</div>

I would take away the Undo option altogether. If someone want to delete something they use the Edit transaction.

This will show up in the history

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 16, 2020, 8:33pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/12 "2020-06-16T20:33:23Z")

</div>

> [@Patch](#):
>
> Another way would be to have context specific history ie the history shown is filtered depending on what screen the user is looking at when they request history.

I think this is great idea. Smaller `History` button could be on every screen as well which would show history relevant to that screen (and sub-screens if applicable).

For example, `History` for `Settings` tab would show changes to anything to do with `Settings`. `History` for `Sales Invoices` tab would show history for all sales invoices. `History` for specific invoice would show history relevant to that invoice only etc.

> [@Joe91](#):
>
> For example, can I create a customer, enter invoices and then in the History undo the Customer Create - the invoices are now posted to a suspense account but maybe it should not allow the Undo

Currently, the only constrain I have in `Undo` is that you can only undo last changes. For example, you can’t undo invoice update if it was updated at later time by someone else. You need to undo their change first. Sure I could add more constraints but then you would find system fighting with you more than you’d like. If you want to undo bunch of stuff, it shouldn’t matter in which order it is done. Or there could be `Undo/Redo` function.

> [@Joe91](#):
>
> Also,when I Undid the Customer Create - it not only deleted the customer, but the Create Customer entry was deleted as well - I think it should have been kept along with a record of the Undo/Delete

Maybe undone operations could just become “gray” and you can `Redo` them. That way it’s not lost.

> [@Davide](#):
>
> I think that undo in accounting should be used only as an extrema ratio and only after a backup like in batch update.

Actually, having history in the program, I no longer need these scary warnings to backup before any batch update. Batch update becomes “safe” operation because it can be easily undone. There is global `Find & Recode` and global `Find & Merge` I’m working on and especially `Find & Merge` has potential to change many records with a single click. Having ability to undo is important.

> [@sharpdrivetek](#):
>
> if you delete an attachment from the **transaction** and then undo the deletion, the attachment can no longer be opened even though the attachment shows at the bottom of the transaction.

I will fix this today.

> [@sharpdrivetek](#):
>
> suggestion to have an option to flush or batch delete the audit trail for administrators (sole users in the case of desktop edition). i have noticed that the audit trail feature adds to the size of the business file.

The database size should not grow that rapidly. Also storage is cheap. Not a concern but there will be ability to purge history.

> [@sharpdrivetek](#):
>
> the audit trail could show the type of transaction and also its reference as two columns so that users can search specifically whether a transaction was modified.

Yeah, but single history line can represent change to 1000 items when it comes to batch operations.

> [@Abeiku](#):
>
> Limited Users are not supposed to see history or the Audit Trail. Audit trail is for administrators and Auditors.

In Manager speak, only users having `Full access` to business can see history for the business. Users with `Limited access` can’t.

> [@Joe91](#):
>
> I would take away the Undo option altogether. If someone want to delete something they use the Edit transaction.

No, `Undo` is crucial as a foundation for more types of batch operations I’m planning to add. For example, `Find & Merge` on tracking codes. You merge two tracking codes into one which can affect thousands of transactions. Takes a few clicks to merge. Shouldn’t take more than a few clicks to unmerge too in case you made a mistake.

---

<div class="post-metadata">

**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\
**Post date:** [June 16, 2020, 8:40pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/13 "2020-06-16T20:40:14Z")

</div>

> [@lubos](#):
>
> I think this is great idea. Smaller `History` button could be on every screen as well which would show history relevant to that screen (and sub-screens if applicable).

This comment made me remember when I requested for a document level history button, where a user with full access could view the history of a document, see here [Audit trail Feature suggestion (User History on Documents)](https://forum.manager.io/t/audit-trail-feature-suggestion-user-history-on-documents/13648)

---

<div class="post-metadata">

**Author:** ![Daniel\_Arthur](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/daniel_arthur/32/15160_2.png) [@Daniel\_Arthur](https://forum.manager.io/u/Daniel_Arthur)\
**Post date:** [June 16, 2020, 8:47pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/14 "2020-06-16T20:47:31Z")

</div>

This new feature is great and definitely in the right direction to making Manager a sought after Accounting Software. I appreciate all the inputs others are giving for improvement to the feature. I will enjoy its use for now and post suggestions when they come up. Thanks a lot, @lubos

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [June 16, 2020, 8:53pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/15 "2020-06-16T20:53:12Z")

</div>

Ok, I can understand the rationale behind an Undo on batch updates and such like but I feel that having the possibilty of deleting accounting records without any trace can only lead to all sorts of problems down the line - whether with auditors or tax authority.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [June 16, 2020, 9:12pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/16 "2020-06-16T21:12:44Z")

</div>

> [@lubos](#):
>
> The database size should not grow that rapidly. Also storage is cheap. Not a concern but there will be ability to purge history.

Yes, storage is cheap, especially from the viewpoint of somebody already paying for access to server farms. But there is more to think about. What about someone who wants to email a backup file to an accountant and runs into an attachment size limit? Likewise, users might need to upload accounting records to attorney’s portals. 5MB limits are fairly common. A few years in business with a modest number of attachments can easily outstrip that.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 16, 2020, 9:14pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/17 "2020-06-16T21:14:58Z")

</div>

The backup function will be improved so you can choose what to include in the backup. If you want the smallest database possible, you would backup without emails, history and attachments.

---

<div class="post-metadata">

**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\
**Post date:** [June 16, 2020, 9:17pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/18 "2020-06-16T21:17:59Z")

</div>

Excellent Idea !

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [June 16, 2020, 9:40pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/19 "2020-06-16T21:40:42Z")

</div>

> [@lubos](#):
>
> Smaller `History` button could be on every screen as well which would show history relevant to that screen (and sub-screens if applicable).

From purely a user interface perspective separate physical buttons are not essential. If could function in an analogous manner to context sensitive help. The button always in the same place but the results depend on what the user is currently doing.

I agree behind the button will be code specific to the current screen.

But separate buttons for each screen could clearly achieve an identical function.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 16, 2020, 9:47pm UTC](https://forum.manager.io/t/new-audit-trail-aka-history/28801/20 "2020-06-16T21:47:01Z")

</div>

The location of `History` button is on “business” level within user interface just like `Backup` button is. This button will give you history over the whole business. Just like backup button gives you backup of the whole business. Contextual history buttons will be elsewhere.

[Next page](https://forum.manager.io/t/new-audit-trail-aka-history/28801.md?page=2)
