- hace 2 días
CONTROL DE INVENTARIO en EXCEL + VBA + ACCESS 🔥 Sistema Profesional
✅ Registrar ventas
✅ Controlar inventario
✅ Administrar productos
✅ Generar reportes
✅ Automatizar procesos
✅ Gestionar clientes y compras
✅ Integrar Excel con Access
💻 Tecnologías utilizadas:
✔ Microsoft Excel
✔ VBA (Visual Basic for Applications)
✔ Microsoft Access
🔥 Ideal para:
• Negocios
• Empresas
• Emprendedores
• Control de stock
• Automatización empresarial
🔗 Contacto de WhatsApp:
https://wa.me/c/584128375067
🔗 Perfil de Instagram:
https://www.instagram.com/negocios_con_excel/
✅ Registrar ventas
✅ Controlar inventario
✅ Administrar productos
✅ Generar reportes
✅ Automatizar procesos
✅ Gestionar clientes y compras
✅ Integrar Excel con Access
💻 Tecnologías utilizadas:
✔ Microsoft Excel
✔ VBA (Visual Basic for Applications)
✔ Microsoft Access
🔥 Ideal para:
• Negocios
• Empresas
• Emprendedores
• Control de stock
• Automatización empresarial
🔗 Contacto de WhatsApp:
https://wa.me/c/584128375067
🔗 Perfil de Instagram:
https://www.instagram.com/negocios_con_excel/
Categoría
📚
AprendizajeTranscripción
00:00Warm greetings. Welcome to this space.
00:04And this is a short, informative, demonstrative video showing how this inventory control application works.
00:10Created using Visual Basic macros in Microsoft Excel with an Access database.
00:17Okay, we have the user maintenance modules, where we can register the employees of our organization.
00:28I can locate here, for example, here I have the record of the data, normal intrinsic data,
00:36and I can save your data along with your image.
00:40I also have the customer registry here, where I can keep a list of registered customers.
00:47that I need to have saved.
00:49When I double-click, I'll have all their data here, and I can eventually modify it, delete it,
00:55or simply by giving it a new one, generating a new sequential number.
01:00Similarly, I also have the suppliers module here,
01:04where I can do the same, have a database of suppliers.
01:09With a double click I have access to your information, which I can modify and delete.
01:14And in the same way I can also create a new one.
01:18Okay, in the inventory module I have product records,
01:22where I have here to create and categorize my inventory products.
01:28I'm going to place one here in a didactic way, for example, this mouse.
01:33By double-clicking it, he will locate his data that is already saved with the image.
01:38I can also, among other things, tell you if the product is active or inactive,
01:45whether or not taxes apply.
01:47I can categorize your product type, manipulate the cost and the selling price
01:55at the moment I want its unit of measurement, in this case it is its unit,
01:58and also have three price levels for retail businesses,
02:03that constantly offer different types of clients one or a second price in their quotes.
02:11Okay, so I can delete the product and also create a new one simply by clicking "new".
02:18Perfect.
02:19I can also have the inventory adjustments module here.
02:22The settings module is, well, simply when I'm about to start using the application,
02:30I need to upload an initial document where I will place all my products.
02:36In other words, I say here to search for products and specify the quantities I am loading.
02:40And having configured the parameters, I say that it is an inventory movement
02:44in a specific type of warehouse.
02:47I can stipulate the date and say that the movement is of the charge type, that I am going to charge inventory.
02:53Also, if I have the registered employee who performed that inventory count,
02:58I can simply locate it and it will be recorded in that inventory movement.
03:04I can save it, and also, if I already have one made, I can simply locate it.
03:12For example, this one, he's going to bring it to me so I can audit it and always be able to verify what I did and when.
03:19I can also export the document as a PDF.
03:22In fact, all the documents generated by the application can be exported as PDFs.
03:28with a sequential number for your audit.
03:32So, this is the inventory module to consolidate.
03:36Just as I have product sheets and inventory adjustments, I also have this transfer module.
03:42It is very common to have more than one inventory depot that we need to control.
03:46What do I have in each storage unit? I mean warehouse, cellar.
03:51And well, it's important to know what I have in each section.
03:54Therefore, the inventory movement that I keep a record of is important.
03:59I can say, well, I'm going to move that inventory from the main warehouse to the secondary warehouse.
04:06I simply locate it and specify the quantities I'm going to move with a double click.
04:11I say, okay, I'll move the save file and that's it. I set the date.
04:16I appoint a person responsible for inventory movement, who will transfer it to me.
04:23I simply select it, double-click it, it will bring it to the form, and I add a note about it being
04:29necessary.
04:30If I tell it to save, it executes it. In this case, I'm not going to do that.
04:33I'm going to audit one that I've already done, because all these inventory transfers are auditable by range.
04:40date and by segmentation of origin and destination deposit.
04:44Here I can select it, double-click it and it will load.
04:50And eventually I can also export it and it gives me the detailed inventory transfer document.
04:57I also have the more detailed transfer report here, which I can export to PDF and also to
05:05Excel for performing any type of verification.
05:08I have the inventory report that calculates the cost of the inventory by weighted average.
05:13I can also export it to PDF, I can export it to Excel, and this inventory also delivers it to me.
05:19I can segment it by department, category, and group.
05:22If I have a segmentation of inventory groups that I want to classify and also by specific warehouses at that time.
05:32In general, if without any segmentation it delivers it to me and tells me, well, you have this much inventory level.
05:38Of course, it's a report that I can export and always have on hand.
05:44Okay, I also have the CARDEX report in the inventory module, which is very important.
05:48The CARDEX module is what gives me the historical movements of a product's record.
05:54from its creation or first arrival.
05:57In this case, well, I tell it to load here and it will deliver them all to me.
06:01But to see the effect, let's locate a specific product.
06:05For example, I simply double-click code 1 and say load.
06:09What does he tell me here? Well, here he tells me that the first move, right, was a purchase that I made a
06:17quantity and tells me, well, I bought 1, stock 1.
06:20Then there was an inventory and it tells me I loaded 6, there were already 7 because 6 plus 1 is 7.
06:27Then there was an adjustment, I subtracted 2, leaving me with 5.
06:31I downloaded 2 here in this setting, from 7 minus 2 it tells me 5.
06:36Then there was a sale of two units, from 5 it went down to 3.
06:41Then there was another sale, subtracting one unit and going from 3 to 2.
06:46Then there was another purchase, I loaded 12 or bought 12, 2 plus 12, 14.
06:52And so, for each record, it informs me what movement it was, what document originated it.
07:00For example, here it tells me what movement it was and the module document that I can audit if something is wrong.
07:06block.
07:06And it tells me exactly about the existence of that record at that moment.
07:11I can also verify it by deposit and, if necessary, I can also export it for further tracking.
07:17detailed.
07:18In case I have to leave, in case I have to check.
07:22This reshuffling of positions is interesting and very important.
07:24And here in my inventory I also have this list of products, which is the same as always.
07:29Where it tabulates the code, the product name, the unit of measure, cost-price and profit margin.
07:36I can segment it by department or by a specific product.
07:40Obviously, the PDF document can also be exported.
07:45Okay, that's the inventory module.
07:47Before talking about the administration department, I want to move on to the purchasing department.
07:52In the purchasing section, I have the purchase order.
07:55It's simply a module where I can set a supplier, the date on which I want to place an order, and so on.
08:02purchase, a supplier.
08:05Right? I establish a sequential number and I can locate the products in my inventory, or rather, the records I have registered.
08:12I have the records I need and I'll start adding the products I want to place a purchase order for.
08:18I simply set the quantities and create the document.
08:22I can save it, I can save this right now, for example, this is number 5, I say save.
08:29He saves it for me, and to find it again I tell him to search, to search here in the list.
08:35Notice that this is document 5 that I just made right here live, it says not resectioned.
08:40It's a document, a purchase order that I haven't selected.
08:44I can segment by resection or non-resection status and also by date ranges.
08:50I can double-click here and it will bring the document here for me.
08:53I can also export it and it generates the document that I can give to my supplier
09:00after having performed any type of verification of any signature, any seal or any observation that remains pending.
09:08Also, if I don't want that there, I can cancel it here, cancel it and that's it, it's canceled and it won't go there.
09:14to exist in the system.
09:15I also have here in the purchase module, purchase resection.
09:19This is the module that does document the inventory resection, that is, it loads the system, increasing the inventory.
09:27I can generate a direct purchase document by setting the date and dynamically locating the supplier,
09:34establishing the supplier's invoice number and specifying in which inventory depot
09:39which I have previously configured in the settings, where I have the inventory.
09:45Or I can simply locate a purchase order that I have already placed.
09:50I'm going to use the example I just did.
09:52This one that says it's not resected, I double-click it and it loads.
09:56I would simply put here which invoice the supplier's invoice has and set up a deposit where it will arrive.
10:05the merchandise.
10:06And I can tell you, here I would put an observation if necessary and here I would put, well, register purchase.
10:12Okay, perfect, I register the purchase and it asks me, are you sure about the purchase cancellation?
10:16There, verify that all fields are correct.
10:19I tell him yes.
10:20And this is a very important point to get to, because he asks me, how am I registering this purchase?
10:25Is it through direct purchase?
10:27Do I need a financial record as well?
10:28Or is it an outstanding balance?
10:31What do I mean?
10:32This is an inventory control application and also includes the necessary administrative records.
10:37It also keeps track of that invoice, whether it is receivable or payable, with corresponding payment numbers.
10:42also.
10:43It also keeps track of expense and income records, actual cash flow, and bank balances.
10:49And we'll see it soon because I want to leave the administrative module for the final part of this video.
10:53that it doesn't take so long.
10:54So, I simply have a direct purchase record here.
10:57This is a module where it asks me, well, which bank it was from, from my bank records, and what currency it was in.
11:03Which rate, the system rate, right?
11:06I pull it here, and I had to have previously set it up in the configuration.
11:10I put all the values here.
11:12For example, I tell him it was Banesco, currency Bolivars, payment method transfer.
11:17I'll pull the amount, have it converted for me.
11:20And I tell it to add to the list and it automatically recognizes the amount paid.
11:26If I say "register here," he will perform the financial registration and at the same time perform the
11:31inventory receipt.
11:32But I'm going to cancel it here for the educational purpose of the video, and I can also give you a record of it.
11:38buy more accounts payable.
11:40I want you to register the inventory and the invoice that is due.
11:43I press here and the accounts payable module opens.
11:47Now I simply have to enter the issue and receipt dates of the invoice.
11:54I already have the supplier's information because it recognizes it and loads it.
11:58I set the credit terms I have with the supplier.
12:01For example, 15, an example.
12:03And I specify what type of invoice it is.
12:05For didactic purposes, I will state that this is a compound.
12:08I double-click and it automatically puts in the base amount and the taxes on those same values.
12:15Withholding applies or not.
12:17If it is a withholding agent, it is specified.
12:19In this case I will put zero for educational purposes.
12:21I will also put "no" in IGTF for educational purposes.
12:24I can also add a note and tell it to register accounts payable.
12:29Let's remember this amount, which is 1,125.77, to do everything live.
12:34I tell him to register.
12:35Ready.
12:37Ready.
12:37I have already received the purchase document.
12:41First, we will verify the purchase order.
12:42Notice that it now says received, which is purchase order 5.
12:47And now I'm going to check the audit listing.
12:50Here I have purchase number 6.
12:52Double click and here I have 1,125.77 which is the total invoice amount.
12:57I have already received this document.
13:00This inventory has already been uploaded.
13:02If I audit code 3 or code 8 right now, it tells me that I uploaded 6 amounts today.
13:09Perfect.
13:10I also have this purchase analysis module which is for analyzing the final purchase costs.
13:15For example, if I spent more money than I needed on this purchase document.
13:21Hey, well, I spent $50 more and I want to sell the profit.
13:26I want to maintain 35, 40 percent, for example.
13:31But I spent too much money.
13:33I need to pay for it.
13:34Well, I tell you, calculate final costs.
13:37And well, he tells me, ah, perfect.
13:39So the cost you paid on the bill is not 77.99, but 81.54.
13:46It needs to be modified.
13:47And this is the cost that will be included in the valuation later.
13:50Same here.
13:51Well, you bought it for 97.16, but you overspent.
13:55Now it actually cost you 101.95.
13:58If you want to continue selling it with a 40 percent profit, you have to set a selling price of
14:03169, not 161.
14:05These are didactic amounts.
14:08Let me clarify.
14:09They are only for the exercise in the video.
14:13Perfect.
14:14This is where I do my analysis.
14:16Okay, perfect.
14:16I can update the cost here.
14:18I can update the sale price or I can cancel the invoice and the purchase directly.
14:22I'm going to return the inventory.
14:24If possible.
14:25In some cases it's possible, in others it's not.
14:28Perfect.
14:28I'm going to clean up and then I'm going out.
14:32And the purchase report is the same old purchase report.
14:34The purchase report is simply, well, I can search for purchase records.
14:39I finally have here the six units of this product that I just resealed.
14:46And I can segment it historically by date range, by specific supplier, or by product.
14:53Incidentally, I can export all these reports to PDF and also to Excel if I need to.
15:00some kind of calculation.
15:01It can be done.
15:03Perfect.
15:04Now let's talk about the sales one.
15:06I have a quote here for the sales one.
15:11And here I can simply say from and until when, choose a specific client from the database, I can
15:21set payment terms, terms that are described in the settings.
15:25Finally, I'll show you how to set the current date, load the products, and this is where the three levels of validity come into play.
15:32price listed on the product page.
15:35For example, this product here, which I have priced at three levels for educational purposes.
15:41I say, well, look, here's price one, if I double-click it, it brings me price one.
15:45Well, here it is.
15:46And I tell him, well, two.
15:48I'm going to select it again for educational purposes and it tells me, well, price two, which is three here, double
15:54Click, it brings me the number three.
15:56He brings me the number three.
15:58And the same here, similarly with price three, which is eleven, I tell you, price three, I select it, double click
16:03And here it is.
16:04I can create my quotation document with three levels for different types of clients, where the price types
16:11entail.
16:14If they are large packages, I can also play around with the quantity of packaging, the cost of packaging, and the number of units of packaging.
16:20These values, for example, the units of the packaging or the units of measurement, the units of the product packaging
16:26They come from the product sheet.
16:28Perfect, this is recognized here.
16:32I have this document here.
16:34We're going to clean here, we're going to clean here and we're going to put this reception, this list, this quote here.
16:41I did it previously.
16:42And we're going to export it so you can see how the quote document is exported to the client.
16:49Perfect.
16:51I also have the one here to register a sale.
16:54Very important.
16:55I can set the modality, for example, delivery note, and I tell it new.
17:00A sequential number is generated for me.
17:02I can dynamically stipulate which client it will be for.
17:07Perfect.
17:07It recognizes the rate from the settings and I set which deposit I'm going to subtract from the inventory
17:14of this sale.
17:15And I simply start loading the products.
17:17Of course, he shows me the existence I have in each one.
17:20It shows me the existence and it shows me the three price levels.
17:24So, I simply tell this mouse, well, I'm going to sell six units, half a dozen, to this supplier.
17:30If this sale requires adding a seller, I'm not referring to the system user.
17:35The user needs to be in the settings area; otherwise, follow up because this is what a user said.
17:41a salesperson, an employee.
17:42I can locate it here.
17:45This is optional.
17:47Here I can also make an observation if necessary and then proceed to register the sale.
17:54Similarly, just like in purchases, he asks me.
17:56I want to register the direct sale, meaning that the customer will pay me in one go.
18:00I need to establish a financial record, which bank the money will be sent to, what the payment currency is,
18:06What is the method?
18:09If you're going to do it by transfer, basically the converted amounts are below.
18:14This is the amount in foreign currency and this is the amount converted to bolivars at the current exchange rate.
18:19I pull the rate, I pull the amount, and I add.
18:22At this moment I could make the sale, the financial income record will add it to my
18:28sales records and it will also subtract the inventory from the sale to this customer.
18:33I'm not going to do it because I want to show here, register sales, more accounts receivable.
18:38Here is the accounts receivable form.
18:41It already retrieves the customer's data because it recognizes it, and also the date.
18:45What he's asking me is the number of days of credit we're going to give the customer.
18:48In this case I will put 7 and it tells me what type of invoice it is.
18:53In this case, I'm going to tell you that it's a delivery note.
18:55Perfect, when I create a delivery note it sets all these values to zero and tells me, well here's the
19:01total in foreign currency and the total in bolivars at the time with that rate.
19:05And I tell GTF no.
19:06And here I would add an observation if necessary.
19:10Register accounts receivable.
19:12Let's remember this amount, 131.
19:14Register C by C, I say yes and that's it.
19:17The sale has already been recorded and the account receivable has been recorded.
19:20Let's audit the list here, and notice that here's delivery note 2; this is the one I just...
19:26to do, 131.
19:27I have it here and I can export it, and I have my customer delivery note recorded this way.
19:35Perfect.
19:36I also have a sales report here.
19:39The sales report is excellent; it brings me results by date range, by product name, or
19:44by customer name,
19:46the total sales I will have historically.
19:49That's why they're called segmenters.
19:51I can export it to PDF if necessary; they are all exportable to PDF.
19:57Or export to Excel here so I can do any kind of calculation that the situation requires.
20:02Perfect.
20:03I also have the sales analysis.
20:05A report that is the most requested every time, at least for me.
20:12I want a report that tells me by day, for example, today.
20:15I press here today, and the start and end dates are set, today's dates.
20:20And I say, see sales analysis.
20:22And what does he have to show me?
20:23You have to show me everything that's been sold.
20:26In this case, 6 units of this product.
20:29And what are you going to show me?
20:29The quantities sold, the total sales including tax, the total net sales, the cost of sales, the
20:37gross margin and the percentage I received from that sale.
20:41But in a similar way I can tell you yesterday, the week, the month, right?
20:47Or simply general.
20:50Give me the general information, I have it here.
20:52I have dates that are my partners because I've had this app for a long time, it's just that now I'm coming to it
20:59making video.
21:00Perfect.
21:01But I can export all those sales in PDF format with the analysis in question.
21:08Here it is.
21:09It can also be exported to Excel to perform any type of calculation.
21:13In this way, we have seen the three main modules.
21:18Let's move on to the administration one.
21:19Okay, perfect.
21:21The administrative process begins with monitoring bank balances.
21:25In other words, I need an initial opening record of what I have in banks.
21:30If I have nothing, then perfect.
21:32Where that movement will be historically recorded as the first movement.
21:39What bank, what processors did I have?
21:42And that's where my financial control of income and revenue begins.
21:46In other words, I'm saying that when I specify which processors, methods, or banks I have for my business operation,
21:53Every time I make a financial income or expense record, it will add up and subtract.
21:59And it will systematically show me the bank balances, as we are seeing here.
22:05He's going to tell me exactly what I have.
22:09Perfect.
22:10I'm going to exit and then here I also have the financial income and expenses module.
22:15I can perform any outgoing transaction, any incoming transaction defined by modality, type and concept.
22:24For example, repair.
22:25I can set a local amount, a currency, the method, the bank, from where the balance should be subtracted.
22:33Here I enter the date and I can save my transaction.
22:38I can look for it too.
22:40Here I have a historical record of income and expense transactions.
22:44Therefore, I also have my income and expense report history.
22:48I can see it here.
22:50I say, I strictly want expenses.
22:53He shows them to me.
22:53It shows me the concept, the currency, the bank, the amount in bolivars, the rate, and the amount in foreign currency.
22:59I can export it to PDF.
23:02And he's going to show it to me here.
23:03Here I have the expense report.
23:05Similarly, I also have the income report.
23:09I didn't upload it here.
23:10I have to upload it here first and then export it.
23:13The income report shows it to me here.
23:15In this way, I can audit it by date range, whichever I want, by currency, and by bank.
23:22specifically.
23:24Also, if I make a mistake with one, I can delete it.
23:27All documents are editable.
23:30I have the accounts receivable section here.
23:32And that's the point I wanted to make.
23:33Here, of course, I can upload an invoice to a service or something that I owe.
23:39I monitor the payment records.
23:41This is the accounts receivable payment control module.
23:44Here in consultation, when I load the list, I have 131.06.
23:49This is the invoice receivable from the sales register we just recorded.
23:54I say double click and it will load the sale.
23:56He's going to tell me, he's due to get paid.
24:00When the client pays me, I would simply put the payment date and currency here.
24:06I would pull the cup.
24:08I'd say, well, it's a preview.
24:09He's going to pay me 35,000, for example.
24:12I do it here, it converts.
24:13He tells me, from 131 it's 71.49.
24:17So, it's a payment, a partial payment.
24:20Which method?
24:21For example, transfer, bank or Banesco.
24:23I would place the reference.
24:25I can add a comment.
24:27And something quite important, I can also assign to this subscription record.
24:32I can dynamically locate, for example, this one that's right here.
24:36This is the payment receipt for me later, in the payment audit of this invoice.
24:41to be able to visualize said movement.
24:43And in fact, I'm going to do it.
24:44Let's register the payment.
24:46I'm going to register the payment here.
24:48Ready.
24:49I paid him 70-something dollars.
24:51Let's go ahead and check, load list.
24:53And here he shows me.
24:54Out of 131, I have 59.57 pending.
24:58I already paid the difference.
25:01And he tells me the new state.
25:02New state of 59.57.
25:04Once you finish paying me, I can continue making all the payments towards that bill.
25:09Now, very important.
25:11Payment tracking.
25:12This is a module that allows me to track all the payments I've made to
25:18an invoice, whether from customers or suppliers.
25:21I tell it to query, load list and I'm going to load this one which is the one we've been working with.
25:26Double click, I say search and it will bring me all the parameters.
25:30He tells me that he is about to collect payment, he tells me the outstanding amount, and who the client is.
25:34He points out some parameters of the invoice.
25:36I can now see from this that it was a delivery note and here I see the payment record.
25:41When I double-click it, I can delete that payment record because I may have made a mistake.
25:48It's valid.
25:49I tell it to delete, it will delete it.
25:52I can view the receipt and here it is.
25:54Look, he's going to show it to me.
25:56Ah, okay, perfect.
25:57Yes that's fine.
25:58Or I can also export the payment receipt because the client is, for example, demanding it.
26:04Ah, perfect.
26:05It turned out very well.
26:07So, with this I can track and have full control over accounts receivable.
26:13Similarly, I'm going to do it quickly.
26:15Similarly, I can do exactly the same with accounts payable.
26:20I have the accounts payable module here.
26:22I have the query module.
26:24Here I have the invoice I just registered for 1,125.77.
26:29I can double-click it and it brings it to me.
26:32Similarly, I can charge a payment.
26:34And I can also locate; I have the tracking module where I can upload an invoice.
26:39For example, this one that is about to be paid and has two assigned payments.
26:45And here, where I can double-click, I'll also be able to delete the record, view the receipt, or export it.
26:51the receipt.
26:52But something very important as well, I can export its tracking.
26:55The tracking is a report that shows me the supplier's data.
26:59In this case, because it's also the same for accounts receivable.
27:02It gives me some details of the invoice, its due date, the status, the days remaining.
27:06And the two payment records show me the amounts in foreign currency, the rate, the amounts in bolivars, and the methods.
27:13In other words, it gives me the complete structure of those financial records.
27:18It also gives me a statement of account.
27:20The statement of accounts is the complete statement of suppliers or customers.
27:24If I say here, accounts receivable, and I tell it to load lists, it shows them to me.
27:28In total I have billed 1,317.
27:31I have been paid 881 and 436 is still pending.
27:35The outstanding ratio is 33%.
27:37I can export this report to Excel.
27:41I can also handle accounts payable.
27:43I have purchased inventory for 8,600.
27:45I paid 389.
27:47For example, I have 8,300 outstanding and I'm 95% in debt.
27:53I can also export it.
27:54It gives me the balance statement and I can segment a specific supplier or customer.
27:59Every time I change here, I can locate a specific one.
28:03If it's C for C, the client tells me here.
28:06If it's C for P, a supplier can place me here.
28:08Perfect.
28:10The payment method.
28:11This is a report by payment method for the day.
28:14I tell him today and I tell him, well, yesterday.
28:17Yesterday, because he already changed the time while recording the video.
28:21That's why yesterday is now.
28:23He tells me, well, it was just a transfer of 35,000.
28:26He tells me, for example.
28:28Me, ah, ok.
28:29Perfect.
28:31In that case, I can see the report and export it to Excel.
28:35But I say, well, without segmentation.
28:37Let's clean.
28:38See the report, for example.
28:40I can export it to Excel and have that document for auditing.
28:46Perfect.
28:46Bank reconciliation.
28:50Bank reconciliation.
28:51Very good.
28:52Okay, I'm going to put pressure on here.
28:54And this isn't really a bank reconciliation as such, but rather a report that shows me,
29:01per record, the bank transactions that I have recorded in the application.
29:05They must be real with the bank.
29:07How does it work?
29:08Good.
29:09I'm going to select a currency here.
29:11I'm going to call him Bolivars.
29:13And the bank I'm going to select, for example, Banesco.
29:16By date range, so it looks a little better, I'm going to tell you, I'm going to select information from
29:22January.
29:22Because January is where I have the most recorded movement.
29:26And I want this example to be clearly appreciated.
29:28Let's remember that it's educational.
29:30What are you going to show me?
29:33When I click "request," he'll show me, "Well, I don't have it here, it must be February, so excuse me."
29:40Let's see, February, here, February, February 28, request.
29:48Okay, here it is.
29:50I have that information from February.
29:52What is he going to show me?
29:53He's going to show me the opening balance for the period, that is, the opening balance I had at Banesco in
29:59February 2026.
30:01It will tell me the total income, the total expenses, and the final balance I had in the
30:07February.
30:08It will also tell me how many income transactions I recorded, how many expense transactions I made, the average income, and
30:16the average expenses.
30:17And what does the record show me?
30:20Well, if I'm saying that I started the month at Banesco with this balance of 255, when I made the
30:29The first record was an expense that I recorded for 58487 expenses.
30:35Then he tells me the balance, it's this amount, minus this amount, he gives me this amount.
30:40And so it goes with all the records. Here it was a sale for 95 and what it does is add it up.
30:4795 plus the previous balance gives me the current balance.
30:51In other words, for each transaction that is recorded, this report will tell me the balance that
30:59It was in every record for every outgoing and incoming transaction.
31:02Of course, I can export it to PDF and view it in detail. It has to be the most suitable for
31:10the true finances of the business, assuming that all bank transaction records were religiously kept here.
31:18So, this is the movement. Of course, this also applies to all banks, even for coins.
31:25If we also have currencies, I want to have this currency control exactly every time I moved currency, every time
31:31I received foreign currency, and every time I spent foreign currency, it will also be delivered to me.
31:37Perfect. Actual cash flow. Actual cash flow is a report where I specify, for example, the year, the
31:43month, the currency of the report, and the bank.
31:46In this case, I'm going to select Banesco and tell it to export cash flow. It will take me to
31:51He's going to bring me, he's going to bring me.
31:55In this case, I have no information for January. Look, I started the transaction in February, and Banesco tells me it was...
32:02255.
32:03The reconciliation report tells me the same thing. There was movement, there was income. Here I have the total income. There were expenses as well.
32:09Here are the expenses, and here's the total Banesco balance for the month. That's what brought it here.
32:18I had no income here. I had one example expense. He arrested it, updated my balance, and brought it to me.
32:24this way.
32:25And he's going to do this for me every month until I have the complete cash flow for the whole year.
32:33real.
32:33It does this for each bank and for each currency, but it also does it generally.
32:39currency.
32:39In other words, I want all the transactions in Bolivars, for example, all the transactions in Bolivars.
32:44Whether it's Banesco or Mercantil bank, all my transactions are in Bolivars. Well, exporting cash flow also...
32:50delivery.
32:51Here's the total, it was 540 and here are all the transactions.
32:55General in Bolivars. He also gives it to me in foreign currency.
32:59Here it is. Here it is. It's less, but here it is. He hands it to me too.
33:06The actual cash flow. Perfect. And this is the income statement.
33:13Okay, management, income statement. I was asked about the year of the report, and in this case, I'll tell you.
33:20in February.
33:21I know I already have data from February. I tell it, okay, export it, and it brings it up.
33:24Well, it brings me the income, it brings me the expenses, and it brings me the taxes if there were any.
33:30Then it brings me here the profit before taxes, it shows me the taxes and the profit I had in the
33:36exercise.
33:37In this case, it puts the date here from February 1st to the 28th, of course.
33:41These are educational data, they are example data, and this is my proposal.
33:46At this point, all that remains is to show here that there is a configuration setting where they can,
33:53This is where all the parameters are placed.
33:55The organization's information is entered here, a logo can be uploaded, and the taxes and percentage are entered here.
34:01Here's the currency, the responsible party, the user who is using the application, and the exchange rate.
34:07This is where it's placed daily.
34:09Inventory depots and invoice types are configured.
34:13This is where you set the parameters for bill payments: banks, method, mode, currencies.
34:19the units of measurement for the products,
34:21the configuration of income and expense parameters.
34:23All of this is fully editable; you can remove it and add your own.
34:27Also, the departmentalization of products, department, category and group, configuration of employee parameters, data,
34:34the degree of intrusion, the area, the position, the reason for resigning, marital status, gender.
34:40Perfect.
34:41The payment terms.
34:43And something I didn't see in the forms, but the concepts of debit note and note can also be applied
34:47credit.
34:48And here are the concepts that you can apply.
34:51Okay, for other types of information, to return to the main view, we go back to the menu.
34:56And he simply shows it to me.
34:58Where are all the PDF reports we exported?
35:01They will always be found in the root folder where I have Excel.
35:06It will always be there.
35:08And this is the application view.
35:11Of course.
35:13This is a User for BBA Excel.
35:16It is a Visual Basic application with Excel macros.
35:20So, having reached this point.
35:21Well, I also have current status here that shows me certain KPIs.
35:26For example, the balance I have in Bolivars, in Foreign Currency.
35:30The movements I've had in Bolivars.
35:32The movements I've had in Currency.
35:34The total accounts receivable and payable updated.
35:37Total inventory.
35:38The cost of inventory.
35:40The income I would have if I sold it.
35:42And the associated gross margin.
35:43And the number of employees, clients, and suppliers I have registered.
35:47If the logo were here, it would also load.
35:49And this is something I can also export to PDF as a current status report.
35:54It can also be adapted.
35:57Good.
35:58At this point, I don't want to make the video any longer.
36:00It's been over 30 minutes.
36:02And we can, if you're interested in learning more about the application.
36:06I invite you to make contact.
36:08The information will remain there in the description.
36:11We can do a slightly more extensive demonstration.
36:14By addressing a situation you may have.
36:16Proposing some kind of adjustment.
36:18To answer any further questions or concerns you may have.
36:21You can also leave it in the description.
36:24I'll be keeping an eye on the comments.
36:26And well.
36:27I look forward to your feedback.
36:32Open to any type of feedback.
36:36They are office automation technologies.
36:38Visual Basic.
36:39Per application.
36:41With Excel.
36:42And the ASICS database.
36:44It's been a pleasure.
36:46And well.
36:47See you in the next installment.
36:48Thank you!
Comentarios