Skip to main content

Accounting System filtering


Forum|alt.badge.img+2

I have an accounting system base using the double-entry bookkeeping method. The user does not have to be concerned about debits or credits because the base is designed to deal with it behind the scenes. For example, to increase an account balance, enter a positive amount in the transaction line item junction table (called Ledger table), and visa-versa (the transaction table is called Journal). The base includes various analysis reports, charts, graphs, reconciliation views, aged reports to show what’s overdue, accrual accounting, funds, multiple currencies, job costing, financials, etc. (Airtable Blocks available in the Pro version features Pivot Tables, and Charts, etc. are really useful!).

I’m trying to filter on two accounts, grouped by aging category, where the transactions are not cleared (i.e., are outstanding). The last filter added (see screenshot) in the Filter dialogue box does not allow me to change the OR to an AND. I’ve tried various combinations but I don’t get the desired result. I can filter one account only, then do the filter on cleared, but I cannot seem to add more than one account?

32 replies

  • Participating Frequently
  • 26 replies
  • March 7, 2018

Hey Ivan, I may not be understanding you correctly, but it seems like you’re trying to filter on a field that can only include one Account ID at a time. Therefore, it wouldn’t be possible to have two Account IDs (Account ID 1100 AND Account ID 1110) because they are mutually exclusive. That may be why Airtable isn’t allowing it.

Does that make sense or is there something that I’m missing?


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • March 8, 2018
Danny11 wrote:

Hey Ivan, I may not be understanding you correctly, but it seems like you’re trying to filter on a field that can only include one Account ID at a time. Therefore, it wouldn’t be possible to have two Account IDs (Account ID 1100 AND Account ID 1110) because they are mutually exclusive. That may be why Airtable isn’t allowing it.

Does that make sense or is there something that I’m missing?


Hey Danny. Thank you for your quick reply!

First, I’m trying to get it to show me all records from 1100 OR 1110. It does that fine so far!

But, I want to filter the above found set further by only showing those records where the value in the Cleared field is empty? I attempted to do so by adding a third filter, but it won’t let me change the OR to an AND. For example, give me all records from account 1100 or 1110, and then only when Cleared is empty?


  • Participating Frequently
  • 26 replies
  • March 8, 2018
Ivan_Carlson wrote:

Hey Danny. Thank you for your quick reply!

First, I’m trying to get it to show me all records from 1100 OR 1110. It does that fine so far!

But, I want to filter the above found set further by only showing those records where the value in the Cleared field is empty? I attempted to do so by adding a third filter, but it won’t let me change the OR to an AND. For example, give me all records from account 1100 or 1110, and then only when Cleared is empty?


Ah, got it! They’ve actually written about this exact issue and how to work around it in this article.

Take a look and let me know if you still have any questions on how to implement it within your own base :grinning_face_with_big_eyes:


  • New Participant
  • 1 reply
  • April 11, 2018

Ivan,

I’m looking at using Airtable in the same way, as an accounting system. Would you be interested in sharing a copy of your base (omitting any confidential information/data, of course) that I could explore as a template?

No worries at all if not, just thought I’d ask!


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • April 11, 2018
Dex_Cure wrote:

Ivan,

I’m looking at using Airtable in the same way, as an accounting system. Would you be interested in sharing a copy of your base (omitting any confidential information/data, of course) that I could explore as a template?

No worries at all if not, just thought I’d ask!


I’d be happy to! I’ll send to you later this evening.


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • April 12, 2018
Dex_Cure wrote:

Ivan,

I’m looking at using Airtable in the same way, as an accounting system. Would you be interested in sharing a copy of your base (omitting any confidential information/data, of course) that I could explore as a template?

No worries at all if not, just thought I’d ask!


Here is the link allowing you to copy the base. It includes some sample data.


Forum|alt.badge.img+3
  • New Participant
  • 4 replies
  • June 1, 2018
Ivan_Carlson wrote:

Here is the link allowing you to copy the base. It includes some sample data.


Hi! I would love if you could share this template with me. Thanks in advance!


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • June 1, 2018
Crystal_S wrote:

Hi! I would love if you could share this template with me. Thanks in advance!


Gladly! Please Message me your email address so I can share.


Forum|alt.badge.img+3
  • New Participant
  • 4 replies
  • June 1, 2018
Ivan_Carlson wrote:

Gladly! Please Message me your email address so I can share.


Thanks so much! crystal.m.soria@gmail.com


@Ivan_Carlson . I’m interested in how your design your accounting system. Please! Could you be of help to me? My e-mail address is dakaachobli@gmail.com


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • June 10, 2018
Daniel_Kojo_Aka wrote:

@Ivan_Carlson . I’m interested in how your design your accounting system. Please! Could you be of help to me? My e-mail address is dakaachobli@gmail.com


I have sent you an invite!


  • New Participant
  • 1 reply
  • June 15, 2018

@Ivan_Carlson
hi ivan!
i am trying too, to use Airtable as an accounting system
would you care to share your base?
thx!
br
:m:


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • June 16, 2018
miro_miro wrote:

@Ivan_Carlson
hi ivan!
i am trying too, to use Airtable as an accounting system
would you care to share your base?
thx!
br
:m:


My pleasure! Please message me your e-mail address so I can share it with you!


  • New Participant
  • 3 replies
  • June 23, 2018

Ivan, looks like you’ve built something that other people like! Can you share with me as well? Thanks


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • June 23, 2018
Eric_Page wrote:

Ivan, looks like you’ve built something that other people like! Can you share with me as well? Thanks


But of course! Please message me your email address so that I can share it with you!


  • New Participant
  • 3 replies
  • June 23, 2018
Ivan_Carlson wrote:

But of course! Please message me your email address so that I can share it with you!


great, thanks. as a new user, it looks like I’ve been limited from sending direct messages. I’ll check in a couple of days and hopefully they’ll have removed the new user limitations.


Forum|alt.badge.img+18
Ivan_Carlson wrote:

But of course! Please message me your email address so that I can share it with you!


@Ivan_Carlson,

You might want to consider copying your base with no data, and then adding it to the Airtable Universe community:

It sounds like it may be a hit, and might save you a bit of work sharing to emails.


  • New Participant
  • 3 replies
  • June 25, 2018

thank you!!! this is awesome


  • New Participant
  • 2 replies
  • August 29, 2018

Hi, is this still available? - cannot get the link to work


Forum|alt.badge.img+18
Jamie_HIBBERT wrote:

Hi, is this still available? - cannot get the link to work


It doesn’t look like it – I also tried searching the name of the base in Airtable Universe, and could not find it.


  • New Participant
  • 2 replies
  • August 30, 2018
Jeremy_Oglesby wrote:

It doesn’t look like it – I also tried searching the name of the base in Airtable Universe, and could not find it.


What a shame as I was looking for something just like this… New here so still finding my feet


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • August 30, 2018
Jamie_HIBBERT wrote:

What a shame as I was looking for something just like this… New here so still finding my feet


This will be rectified soon. I was cleaning up some workspaces and an unintended consequence was removing it from Universe.


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • August 30, 2018
Jamie_HIBBERT wrote:

What a shame as I was looking for something just like this… New here so still finding my feet


This will be rectified soon. I was cleaning up some workspaces and an unintended consequence was removing it from Universe. See the new and improved base!


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • August 30, 2018
Jeremy_Oglesby wrote:

It doesn’t look like it – I also tried searching the name of the base in Airtable Universe, and could not find it.



Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 36 replies
  • August 30, 2018
Jamie_HIBBERT wrote:

Hi, is this still available? - cannot get the link to work


NEW AND IMPROVED!


Reply